- 30 9月, 2003 19 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
< o Fixed PL/Tcl's spi_prepare to accept full qualified type names in < the parameter type list
-
由 Bruce Momjian 提交于
Neil Conway
-
由 Bruce Momjian 提交于
> o Fixed PL/Tcl's spi_prepare to accept full qualified type names in > the parameter type list
-
由 Jan Wieck 提交于
type name specification. Jan
-
由 Bruce Momjian 提交于
Before patch: test=# select pg_get_constraintdef(oid) from pg_constraint; pg_get_constraintdef ------------------------------------------------------------------------------------------------- CHECK (VALUE >= 0) CHECK ((((a)::text = 'asdf'::text) OR ((a)::text = 'fdsa'::text)) OR ((a)::text = 'dfd'::text)) PRIMARY KEY (b) FOREIGN KEY (a) REFERENCES test2(b) UNIQUE (b) (5 rows) test=# select pg_get_constraintdef(oid, true) from pg_constraint; pg_get_constraintdef ----------------------------------------------------------------------------------- CHECK VALUE >= 0 CHECK a::text = 'asdf'::text OR a::text = 'fdsa'::text OR a::text = 'dfd'::text PRIMARY KEY (b) FOREIGN KEY (a) REFERENCES test2(b) UNIQUE (b) (5 rows) After patch: test=# select pg_get_constraintdef(oid) from pg_constraint; pg_get_constraintdef ------------------------------------------------------------------------------------------------- CHECK (VALUE >= 0) CHECK ((((a)::text = 'asdf'::text) OR ((a)::text = 'fdsa'::text)) OR ((a)::text = 'dfd'::text)) PRIMARY KEY (b) FOREIGN KEY (a) REFERENCES test2(b) UNIQUE (b) (5 rows) test=# select pg_get_constraintdef(oid, true) from pg_constraint; pg_get_constraintdef ----------------------------------------------------------------------------------- CHECK (VALUE >= 0) ` CHECK (a::text = 'asdf'::text OR a::text = 'fdsa'::text OR a::text = 'dfd'::text) PRIMARY KEY (b) FOREIGN KEY (a) REFERENCES test2(b) UNIQUE (b) (5 rows) It's important that those brackets are there to (a) match all other constraints and (b) so that people can just copy and paste them and it will work as SQL. Christopher Kings-Lynne
-
由 Bruce Momjian 提交于
areas are for the lifetime of the backend and in the interests of not breaking something that's not broken I left alone. Note for anyone reading this and wanting it for tsearch-v2-stable (i.e. for 7.3 backend) this patch probably will not apply cleanly to that source. It should be simple enough to see what's going on and apply the changes by hand if need be. -- Nigel J. Andrews
-
由 Bruce Momjian 提交于
this query?" logic in postgres.c Also, make it print "duration:" like log_duration. Neil Conway
-
由 Bruce Momjian 提交于
don't deal well with tuples having dropped columns. The attached fixes the issue. Please apply. Joe Conway
-
由 Bruce Momjian 提交于
> > a) Write documentation how the win32 console needs to be set up so that > > psql can handle 8-bit characters. > > Where should it be added? The Section "Installation on Windows" in the > > Administrator's Guide seems natural to me. > > > > b) Add code to psql that prints a warning on startup of psql when the > > console codepage differs from the windows codepage, something like > > > > Warning: Console codepage (850) differs from windows codepage (1252) > > 8-bit characters will not work correctly. See PostgreSQL > > documentation "Installation on Windows" for details. > Attached are two patches: - installdoc.patch contains an additional paragraph on the win32 console codepage for the chapter "Installation on Windows" Due to a lack of SGML-tools, I have only edited the text and not tested the SGML code - please check it before merging into the CVS branch. - psqlcodepage.patch adds the warning about a problematic codepage to psql. Christoph Dalitz
-
由 Bruce Momjian 提交于
arch-dev.sgml Neil Conway
-
由 Bruce Momjian 提交于
a column dropped. B) Updated the documentation for the 7.4 release. Steven Singer
-
由 Bruce Momjian 提交于
releases. Rod Taylor
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> * Have SHOW ALL and pg_settings show descriptions for server-side variables(Joe)
-
由 Peter Eisentraut 提交于
changes between 7.3 and 7.4, for example quoting and function names.
-
由 Peter Eisentraut 提交于
were they doing here anyway?
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
-
- 29 9月, 2003 10 次提交
-
-
由 Peter Eisentraut 提交于
this should help people get started in 7.4 as well.
-
由 Peter Eisentraut 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
Also, make :alnum: character class directly dependent on isalnum() rather than guessing.
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
-
由 Tom Lane 提交于
to be less dangerous, and often faster as well. ExprState trees are not kept across transaction boundaries; this eliminates problems with resource leakage in failed transactions. But by keeping them in a per-transaction EState, we can safely arrange for a single ExprState to be shared by all the expression evaluations done in a given plpgsql function call. (Formerly it seemed necessary to create and destroy an ExprState for each exec_eval_simple_expr() call.) This saves time in any scenario where a plpgsql function executes more than one expression. Seems to be about as fast as 7.3 for simple cases, and significantly faster for functions that do a lot of calculations.
-
由 Tom Lane 提交于
post-abort cleanup hooks. I'm surprised that we have not needed this already, but I need it now to fix a plpgsql problem, and the usefulness for other dynamically loaded modules seems obvious.
-
- 28 9月, 2003 11 次提交
-
-
由 Tom Lane 提交于
in the RI triggers for ON DELETE/UPDATE SET DEFAULT. The code depended way too much on knowledge of plan structure, and yet still would fail if the generated query got rewritten by rules.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
Nigel J. Andrews
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
M?rcio Dick Smiderle
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
sequence for dumping.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
method. Fix a number of places where shared libraries were linked without mentioning all the libraries they depend on; the Darwin and AIX ports are known to require this, and it doesn't seem to hurt any other supported platforms. (Hence, remove code in pl/tcl makefile that tried to avoid mentioning other libs if not needed.)
-