OSDN Git Service
Peter Eisentraut [Sat, 4 Oct 2003 01:06:38 +0000 (01:06 +0000)]
Format help message internally consistent.
Peter Eisentraut [Sat, 4 Oct 2003 01:04:46 +0000 (01:04 +0000)]
Change transaction status indicator in prompt from %T to %x.
Peter Eisentraut [Fri, 3 Oct 2003 22:39:34 +0000 (22:39 +0000)]
New translation
Tom Lane [Fri, 3 Oct 2003 20:10:59 +0000 (20:10 +0000)]
Issue 'SET check_function_bodies = false' to suppress possible restore
failures in SQL functions, due to forward references or unqualified
references to objects in other schemas. Per recent discussion.
Tom Lane [Fri, 3 Oct 2003 19:26:49 +0000 (19:26 +0000)]
Add GUC parameter check_function_bodies to control whether validation
of function bodies is done at CREATE FUNCTION time. This is normally
true but can be set false to avoid problems with forward references,
wrong schema search path, etc. This is just the backend patch, still
need to adjust pg_dump to make use of it.
Tom Lane [Fri, 3 Oct 2003 18:26:14 +0000 (18:26 +0000)]
Cause PQescapeString to stop processing at a null character, rather
than generating an invalid output string. Per observation and patch
from Igor Shevchenko. Further code cleanup and documentation by
Tom Lane.
Tom Lane [Fri, 3 Oct 2003 17:04:48 +0000 (17:04 +0000)]
Remove assorted compilation failures introduced by latest ecpg changes.
Also remove -g, which has no business in CPPFLAGS in the first place,
let alone being hardwired there by a sub-Makefile.
Michael Meskes [Fri, 3 Oct 2003 10:07:28 +0000 (10:07 +0000)]
Hide Informix datatypes. They are not seen by our built process anymore.
PostgreSQL Daemon [Fri, 3 Oct 2003 03:08:14 +0000 (03:08 +0000)]
brand her beta4
Tom Lane [Thu, 2 Oct 2003 23:19:44 +0000 (23:19 +0000)]
Add a bit more locking to vac_update_relstats and vac_update_dbstats
to make them comparable to what UpdateStats does in the same situation.
I'm not certain two instances of vac_update_relstats could run in
parallel for the same relation, but parallel invocations of vac_update_dbstats
do seem possible.
Tom Lane [Thu, 2 Oct 2003 22:24:54 +0000 (22:24 +0000)]
When dumping CREATE INDEX, must show opclass name if the opclass isn't
in the schema search path. Otherwise pg_dump doesn't correctly dump
scenarios where a custom opclass is created in 'public' and then used
by indexes in other schemas.
Tom Lane [Thu, 2 Oct 2003 19:52:44 +0000 (19:52 +0000)]
Do not return from PQrequestCancel until postmaster has finished
processing the request; this ensures that the request won't be taken
to cancel a subsequently-issued query. Race condition originally
noted by Oliver Jowett in the context of JDBC, but libpq has it too.
Tom Lane [Thu, 2 Oct 2003 14:47:44 +0000 (14:47 +0000)]
Don't use 0 as a spelling of NULL.
Peter Eisentraut [Thu, 2 Oct 2003 06:39:31 +0000 (06:39 +0000)]
Add documentation about \pset footer to \?.
from Patrick Welche
Peter Eisentraut [Thu, 2 Oct 2003 06:36:37 +0000 (06:36 +0000)]
String fixes/improvements found by Alvaro Herrera
Peter Eisentraut [Thu, 2 Oct 2003 06:34:04 +0000 (06:34 +0000)]
Change some notices to warnings and vice versa according to criteria
developed on -hackers.
Peter Eisentraut [Thu, 2 Oct 2003 06:32:46 +0000 (06:32 +0000)]
Remove NOTICE about foreign key creating implicit triggers, because it no
longer conveys useful information.
Tom Lane [Thu, 2 Oct 2003 03:51:40 +0000 (03:51 +0000)]
Attached is a patch for contrib/tablefunc. It fixes two issues raised by
Lars Boegild Thomsen (full email below) and also corrects the regression
expected output for a recent backend message adjustment. Please apply.
Joe Conway
Tom Lane [Wed, 1 Oct 2003 21:47:42 +0000 (21:47 +0000)]
Add code to check that IF/WHILE/EXIT test expressions are boolean,
and try to coerce the values to boolean if not. Per recent discussions.
Tom Lane [Wed, 1 Oct 2003 21:30:53 +0000 (21:30 +0000)]
Repair RI trigger visibility problems (this time for sure ;-)) per recent
discussion on pgsql-hackers: in READ COMMITTED mode we just have to force
a QuerySnapshot update in the trigger, but in SERIALIZABLE mode we have
to run the scan under a current snapshot and then complain if any rows
would be updated/deleted that are not visible in the transaction snapshot.
Tom Lane [Tue, 30 Sep 2003 03:22:33 +0000 (03:22 +0000)]
Adjust documentation examples to match recent error message rewordings.
A couple other minor fixes.
Tom Lane [Tue, 30 Sep 2003 01:56:11 +0000 (01:56 +0000)]
Minor copy-editing.
Tom Lane [Tue, 30 Sep 2003 01:26:29 +0000 (01:26 +0000)]
Use slightly less broken markup.
Tom Lane [Tue, 30 Sep 2003 00:59:51 +0000 (00:59 +0000)]
heap_open => relation_open to avoid unwanted restriction on relkind.
Per gripe from Gaetano Mendola.
Tom Lane [Mon, 29 Sep 2003 23:40:26 +0000 (23:40 +0000)]
Adjust btree index build procedure so that the btree metapage looks
invalid (has the wrong magic number) until the build is entirely
complete. This turns out to cost no additional writes in the normal
case, since we were rewriting the metapage at the end of the process
anyway. In normal scenarios there's no real gain in security, because
a failed index build would roll back the transaction leaving an unused
index file, but for rebuilding shared system indexes this seems to add
some useful protection.
Bruce Momjian [Mon, 29 Sep 2003 23:16:44 +0000 (23:16 +0000)]
Release updates by Tom.
Tom Lane [Mon, 29 Sep 2003 22:06:40 +0000 (22:06 +0000)]
Improve context display for failures during COPY IN, as recently
discussed on pghackers.
Bruce Momjian [Mon, 29 Sep 2003 21:42:04 +0000 (21:42 +0000)]
Update Jan's completed item.
Bruce Momjian [Mon, 29 Sep 2003 21:41:29 +0000 (21:41 +0000)]
Remove, already done:
< o Fixed PL/Tcl's spi_prepare to accept full qualified type names in
< the parameter type list
Bruce Momjian [Mon, 29 Sep 2003 21:25:43 +0000 (21:25 +0000)]
Update HISTORY for 7.4.
Neil Conway
Bruce Momjian [Mon, 29 Sep 2003 21:15:19 +0000 (21:15 +0000)]
Add:
> o Fixed PL/Tcl's spi_prepare to accept full qualified type names in
> the parameter type list
Jan Wieck [Mon, 29 Sep 2003 19:24:06 +0000 (19:24 +0000)]
Fixed type lookup in spi_prepare for possible qualified
type name specification.
Jan
Bruce Momjian [Mon, 29 Sep 2003 18:55:56 +0000 (18:55 +0000)]
The brackets aren't put on the CHECK constraints properly.
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 [Mon, 29 Sep 2003 18:54:38 +0000 (18:54 +0000)]
I've not changed any malloc/calloc to palloc. It looks to me that these memory
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 [Mon, 29 Sep 2003 18:50:58 +0000 (18:50 +0000)]
This patch fixes an obvious bug in the "should I print the duration of
this query?" logic in postgres.c
Also, make it print "duration:" like log_duration.
Neil Conway
Bruce Momjian [Mon, 29 Sep 2003 18:22:48 +0000 (18:22 +0000)]
I discovered that TupleDescGetAttInMetadata and BuildTupleFromCStrings
don't deal well with tuples having dropped columns. The attached fixes
the issue. Please apply.
Joe Conway
Bruce Momjian [Mon, 29 Sep 2003 18:21:33 +0000 (18:21 +0000)]
> >
> > 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 [Mon, 29 Sep 2003 18:18:35 +0000 (18:18 +0000)]
This patch makes a few incremental improvements to geqo.sgml and
arch-dev.sgml
Neil Conway
Bruce Momjian [Mon, 29 Sep 2003 18:16:48 +0000 (18:16 +0000)]
A) Fixes a bug that prevented mirroring of data on a table that has had
a column dropped.
B) Updated the documentation for the 7.4 release.
Steven Singer
Bruce Momjian [Mon, 29 Sep 2003 18:15:12 +0000 (18:15 +0000)]
Change 7.3.4 release note format to match the rest of the 7.3.x
releases.
Rod Taylor
Bruce Momjian [Mon, 29 Sep 2003 18:06:48 +0000 (18:06 +0000)]
Update release notes.
Bruce Momjian [Mon, 29 Sep 2003 16:52:14 +0000 (16:52 +0000)]
Add:
> * Have SHOW ALL and pg_settings show descriptions for server-side variables(Joe)
Peter Eisentraut [Mon, 29 Sep 2003 16:41:33 +0000 (16:41 +0000)]
Adjust the new Norwegian translation for some of the easier message
changes between 7.3 and 7.4, for example quoting and function names.
Peter Eisentraut [Mon, 29 Sep 2003 16:39:18 +0000 (16:39 +0000)]
Apparently, gettext doesn't like double parentheses around argument. What
were they doing here anyway?
Peter Eisentraut [Mon, 29 Sep 2003 16:38:04 +0000 (16:38 +0000)]
Make message fit guidelines.
Peter Eisentraut [Mon, 29 Sep 2003 16:37:29 +0000 (16:37 +0000)]
Eliminate another gratuitous message wording difference.
Peter Eisentraut [Mon, 29 Sep 2003 10:57:06 +0000 (10:57 +0000)]
New Norwegian translation by Trond Endrestøl, actually made for 7.3, but
this should help people get started in 7.4 as well.
Peter Eisentraut [Mon, 29 Sep 2003 09:51:29 +0000 (09:51 +0000)]
New translations
Bruce Momjian [Mon, 29 Sep 2003 04:50:36 +0000 (04:50 +0000)]
Update HISTORY to current.
Bruce Momjian [Mon, 29 Sep 2003 04:20:22 +0000 (04:20 +0000)]
Fix #error message to mention renamed option --disable-spinlocks.
Bruce Momjian [Mon, 29 Sep 2003 03:32:05 +0000 (03:32 +0000)]
Update docs that point to thread test program.
Tom Lane [Mon, 29 Sep 2003 00:21:58 +0000 (00:21 +0000)]
Fix broken definition of :print: character class, per Bruno Wolff.
Also, make :alnum: character class directly dependent on isalnum()
rather than guessing.
Peter Eisentraut [Mon, 29 Sep 2003 00:17:42 +0000 (00:17 +0000)]
Translation update
Peter Eisentraut [Mon, 29 Sep 2003 00:05:25 +0000 (00:05 +0000)]
More message editing, some suggested by Alvaro Herrera
Tom Lane [Sun, 28 Sep 2003 23:37:45 +0000 (23:37 +0000)]
Restructure plpgsql's caching of 'simple' expression evaluation trees
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 [Sun, 28 Sep 2003 23:26:20 +0000 (23:26 +0000)]
Add a mechanism to let dynamically loaded modules register post-commit/
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.
Tom Lane [Sun, 28 Sep 2003 02:11:23 +0000 (02:11 +0000)]
Now that we have UPDATE tab SET col = DEFAULT, get rid of horrid hack
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 [Sun, 28 Sep 2003 01:19:33 +0000 (01:19 +0000)]
Update docs on function call permissions in view, from Tom.
Bruce Momjian [Sun, 28 Sep 2003 00:25:22 +0000 (00:25 +0000)]
Adjust pgindent for newer awks.
Nigel J. Andrews
Bruce Momjian [Sun, 28 Sep 2003 00:22:58 +0000 (00:22 +0000)]
Allow pgindent to work with newer BSD indents.
Bruce Momjian [Sat, 27 Sep 2003 22:24:49 +0000 (22:24 +0000)]
Make dbf2pg safe for non-ASCII character sets.
M?rcio Dick Smiderle
Bruce Momjian [Sat, 27 Sep 2003 22:23:35 +0000 (22:23 +0000)]
Mark Linux for threads.
Tom Lane [Sat, 27 Sep 2003 22:10:01 +0000 (22:10 +0000)]
Remove erroneous restriction that -t cannot be used to select a
sequence for dumping.
Bruce Momjian [Sat, 27 Sep 2003 21:26:09 +0000 (21:26 +0000)]
Update bsd indent patch.
Bruce Momjian [Sat, 27 Sep 2003 21:19:47 +0000 (21:19 +0000)]
Cleanup pgindent patch.
Tom Lane [Sat, 27 Sep 2003 20:38:19 +0000 (20:38 +0000)]
Got the link order wrong :-(
Tom Lane [Sat, 27 Sep 2003 19:35:32 +0000 (19:35 +0000)]
Adjust Darwin build to use the default 'two level namespace' linking
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.)
Jan Wieck [Sat, 27 Sep 2003 19:15:34 +0000 (19:15 +0000)]
Fixed calculation of bid when generating accounts. Used to create
accounts.bid values of zero.
Jan
Tom Lane [Sat, 27 Sep 2003 18:16:35 +0000 (18:16 +0000)]
Fix typo in message.
Bruce Momjian [Sat, 27 Sep 2003 17:29:30 +0000 (17:29 +0000)]
Add compile step to instructions.
Bruce Momjian [Sat, 27 Sep 2003 16:27:57 +0000 (16:27 +0000)]
Make dump files created by initdb have consistent EOL termination, to
pass COPY's EOL tests.
Bruce Momjian [Sat, 27 Sep 2003 16:24:45 +0000 (16:24 +0000)]
Finalize configuration of thread_test program.
Jan Wieck [Sat, 27 Sep 2003 15:34:06 +0000 (15:34 +0000)]
Changed the logic when a CAST is dumped according to discussion
on pgsql-hackers.
A cast is included in the dump output if any of the objects does
not belong to a system namespace and all of the non-system namespace
objects belong to dumped namespaces. System namespace is defined
as nspname begins with "pg_".
Jan
Bruce Momjian [Sat, 27 Sep 2003 15:32:48 +0000 (15:32 +0000)]
Rename thread compile flag. Move thread test program to tools/thread,
and improve tests.
Bruce Momjian [Sat, 27 Sep 2003 14:06:21 +0000 (14:06 +0000)]
Small SGML cleanup from Jeroen Ruigrok/asmodai
Peter Eisentraut [Sat, 27 Sep 2003 09:29:31 +0000 (09:29 +0000)]
You can't NLS-enable a program component by just putting gettext() around
every string, especially if some of the output should be fixed-format
machine-readable. This needs to be more carefully sorted out. Also, make
the help message generated by --help-config -h be more similar in style to
the others.
Peter Eisentraut [Sat, 27 Sep 2003 09:21:26 +0000 (09:21 +0000)]
The formatting of the display of the locale names assumed that locale names
are not longer than 8 characters. But sometimes they are, and that made
the display quite ugly. So just format them vertically so that everyone
can read them.
Bruce Momjian [Sat, 27 Sep 2003 00:10:31 +0000 (00:10 +0000)]
Document that functions are checked independently of the view
permissions.
Bruce Momjian [Fri, 26 Sep 2003 17:47:44 +0000 (17:47 +0000)]
Add "tuning" section to install instructions.
Tom Lane [Fri, 26 Sep 2003 17:39:13 +0000 (17:39 +0000)]
Move -D_GNU_SOURCE hack from port header to template, so that
configure's tests see the same compilation environment as the code.
Per discussion with Stephan Szabo.
Peter Eisentraut [Fri, 26 Sep 2003 15:27:37 +0000 (15:27 +0000)]
Various message fixes, among those fixes for the previous round of fixes
Peter Eisentraut [Fri, 26 Sep 2003 15:25:39 +0000 (15:25 +0000)]
Translation update
Michael Meskes [Fri, 26 Sep 2003 15:16:29 +0000 (15:16 +0000)]
Fixed segfault after error in parsing precision argument.
Tom Lane [Fri, 26 Sep 2003 01:17:01 +0000 (01:17 +0000)]
Fix tid scan evaluation of non-constant TID values; can't try to do it
during ExecInitTidScan, because the rest of the executor isn't ready.
Tom Lane [Thu, 25 Sep 2003 23:02:12 +0000 (23:02 +0000)]
Make the world safe (more or less) for dropped columns in plpgsql rowtypes.
Tom Lane [Thu, 25 Sep 2003 19:41:49 +0000 (19:41 +0000)]
tlist_matches_tupdesc() needs to defend itself against dropped columns.
Tom Lane [Thu, 25 Sep 2003 18:58:36 +0000 (18:58 +0000)]
Get rid of ReferentialIntegritySnapshotOverride by extending Executor API
to allow es_snapshot to be set to SnapshotNow rather than a query snapshot.
This solves a bug reported by Wade Klaver, wherein triggers fired as a
result of RI cascade updates could misbehave.
Tom Lane [Thu, 25 Sep 2003 16:16:35 +0000 (16:16 +0000)]
Fix regression error messages for platforms Peter doesn't use.
Tom Lane [Thu, 25 Sep 2003 15:58:06 +0000 (15:58 +0000)]
Fix grammatical error introduced into error message.
Peter Eisentraut [Thu, 25 Sep 2003 15:48:17 +0000 (15:48 +0000)]
Forget to update the real source of the regression test results after
message editing.
Peter Eisentraut [Thu, 25 Sep 2003 06:58:07 +0000 (06:58 +0000)]
Message editing: remove gratuitous variations in message wording, standardize
terms, add some clarifications, fix some untranslatable attempts at dynamic
message building.
Bruce Momjian [Thu, 25 Sep 2003 02:27:54 +0000 (02:27 +0000)]
Update Japanese FAQ, from Jun Kuwamura
Bruce Momjian [Wed, 24 Sep 2003 19:05:32 +0000 (19:05 +0000)]
Fix creation of temporary sequences in ecpg, per report from Edmund Bacon.
Tom Lane [Wed, 24 Sep 2003 18:54:02 +0000 (18:54 +0000)]
Repair some REINDEX problems per recent discussions. The relcache is
now able to cope with assigning new relfilenode values to nailed-in-cache
indexes, so they can be reindexed using the fully crash-safe method. This
leaves only shared system indexes as special cases. Remove the 'index
deactivation' code, since it provides no useful protection in the shared-
index case. Require reindexing of shared indexes to be done in standalone
mode, but remove other restrictions on REINDEX. -P (IgnoreSystemIndexes)
now prevents using indexes for lookups, but does not disable index updates.
It is therefore safe to allow from PGOPTIONS. Upshot: reindexing system catalogs
can be done without a standalone backend for all cases except
shared catalogs.
Marc G. Fournier [Wed, 24 Sep 2003 18:09:15 +0000 (18:09 +0000)]
another totally benign, test commit
Marc G. Fournier [Wed, 24 Sep 2003 18:08:20 +0000 (18:08 +0000)]
test 2, benign, no change
Marc G. Fournier [Wed, 24 Sep 2003 18:05:36 +0000 (18:05 +0000)]
not change, just added a space to test something
Tom Lane [Wed, 24 Sep 2003 05:38:38 +0000 (05:38 +0000)]
Add positive defense against dropped columns, per suggestion from
Christopher Kings-Lynne. Also fix a couple more schema-awareness issues.
Tom Lane [Tue, 23 Sep 2003 23:31:52 +0000 (23:31 +0000)]
Issue CREATE SCHEMA as the originally connecting user, with an
AUTHORIZATION clause to specify the desired owner. This allows a
superuser to restore schemas owned by users without CREATE-SCHEMA
permissions (ie, schemas originally created by a superuser using
AUTHORIZATION). --no-owner can be specified to suppress the
AUTHORIZATION clause if need be.
Tom Lane [Tue, 23 Sep 2003 22:48:53 +0000 (22:48 +0000)]
pg_dump/pg_restore now always use SET SESSION AUTHORIZATION, not \connect,
to control object ownership. The use-set-session-authorization and
no-reconnect switches are obsolete (still accepted on the command line,
but they don't do anything). This is a precursor to fixing handling
of CREATE SCHEMA, which will be a separate commit.