]> granicus.if.org Git - postgresql/log
postgresql
19 years agoSuppress signed-vs-unsigned-char warnings in contrib.
Tom Lane [Sat, 24 Sep 2005 19:14:05 +0000 (19:14 +0000)]
Suppress signed-vs-unsigned-char warnings in contrib.

19 years agoSuppress signed-vs-unsigned-char warnings.
Tom Lane [Sat, 24 Sep 2005 17:53:28 +0000 (17:53 +0000)]
Suppress signed-vs-unsigned-char warnings.

19 years agoIn a machine where INT64_IS_BUSTED, we can only support 32-bit values
Tom Lane [Sat, 24 Sep 2005 15:34:07 +0000 (15:34 +0000)]
In a machine where INT64_IS_BUSTED, we can only support 32-bit values
for int8 and related types.  However we might be talking to a client
that has working int64; so pq_getmsgint64 really needs to check the
incoming value and throw an overflow error if we can't represent it
accurately.

19 years agoAdd comments explaining clauses used by CREATE ROLE but not ALTER.
Bruce Momjian [Fri, 23 Sep 2005 22:25:25 +0000 (22:25 +0000)]
Add comments explaining clauses used by CREATE ROLE but not ALTER.

19 years agoAdd:
Bruce Momjian [Fri, 23 Sep 2005 21:55:01 +0000 (21:55 +0000)]
Add:

> * Simplify dropping roles that have objects in several databases

19 years agoAdd:
Bruce Momjian [Fri, 23 Sep 2005 20:41:39 +0000 (20:41 +0000)]
Add:

>  o Allow PL/PgSQL to support WITH HOLD cursors

19 years agoAdd:
Bruce Momjian [Fri, 23 Sep 2005 20:32:49 +0000 (20:32 +0000)]
Add:

>
>  o Display IN, INOUT, and OUT parameters in \df+
>
>    It probably requires psql to output newlines in the proper
>    column, which is already on the TODO list.

19 years agoRemove xid wraparound mention, because it was already done in 8.0, per Neil.
Bruce Momjian [Fri, 23 Sep 2005 16:36:35 +0000 (16:36 +0000)]
Remove xid wraparound mention, because it was already done in 8.0, per Neil.

19 years agoFix typo in comment.
Tom Lane [Fri, 23 Sep 2005 15:36:57 +0000 (15:36 +0000)]
Fix typo in comment.

19 years agoDocument that chkpass ignores password characters after the eighth.
Tom Lane [Fri, 23 Sep 2005 15:05:04 +0000 (15:05 +0000)]
Document that chkpass ignores password characters after the eighth.

19 years agoAdd:
Bruce Momjian [Fri, 23 Sep 2005 03:06:03 +0000 (03:06 +0000)]
Add:

> * Add function to report the time of the most recent server reload

19 years agoAdd:
Bruce Momjian [Fri, 23 Sep 2005 03:04:24 +0000 (03:04 +0000)]
Add:

> * Add options to pg_config to show the share_dir, sysconfdir,
>   pkgincludedir, and localedir
>

19 years agoClarify autovacuum wording.
Bruce Momjian [Fri, 23 Sep 2005 02:42:34 +0000 (02:42 +0000)]
Clarify autovacuum wording.

19 years agoPlease find attached a patch which tells about what the spiffy,
Bruce Momjian [Fri, 23 Sep 2005 02:25:35 +0000 (02:25 +0000)]
Please find attached a patch which tells about what the spiffy,
integrated autovacuum now does :)

David Fetter

19 years agoMention that autovacuum also needs stats.
Bruce Momjian [Fri, 23 Sep 2005 02:06:58 +0000 (02:06 +0000)]
Mention that autovacuum also needs stats.

19 years agoAttached patch takes a swing at improving the autovacuum wording in
Bruce Momjian [Fri, 23 Sep 2005 02:01:35 +0000 (02:01 +0000)]
Attached patch takes a swing at improving the autovacuum wording in
maintenance.sgml.

Robert Treat

[ Also fix create domain markup.]

19 years agoAdd warning about DOMAINs.
Bruce Momjian [Thu, 22 Sep 2005 23:56:46 +0000 (23:56 +0000)]
Add warning about DOMAINs.

David Fetter

19 years agoAdd:
Bruce Momjian [Thu, 22 Sep 2005 23:54:09 +0000 (23:54 +0000)]
Add:

> * Allow CREATE INDEX to take an additional parameter for use with
>   special index types
>

19 years agoMove table constraint patch up into the main new features section of the
Bruce Momjian [Thu, 22 Sep 2005 23:47:44 +0000 (23:47 +0000)]
Move table constraint patch up into the main new features section of the
release notes.

19 years agoFix bug introduced into indexable_outerrelids() by an ill-considered
Tom Lane [Thu, 22 Sep 2005 23:25:07 +0000 (23:25 +0000)]
Fix bug introduced into indexable_outerrelids() by an ill-considered
"optimization".  When we find a potentially useful joinclause, we
have to add all its other required_relids to the result, not only the
other clause_relids.  They are different in the case of a joinclause
whose applicability has to be postponed due to outer join.  We have
to include the extra rels because otherwise, after best_inner_indexscan
masks the join rels with index_outer_relids, it will always fail to
find the joinclause as applicable.  Per report from Husam Tomeh.

19 years agoAdd "basic" for table partitioning.
Bruce Momjian [Thu, 22 Sep 2005 23:24:58 +0000 (23:24 +0000)]
Add "basic" for table partitioning.

19 years agoAdd instructions.
Bruce Momjian [Thu, 22 Sep 2005 21:59:50 +0000 (21:59 +0000)]
Add instructions.

19 years agoAdd "codelines" script to compute number of lines in a releaes.
Bruce Momjian [Thu, 22 Sep 2005 21:58:58 +0000 (21:58 +0000)]
Add "codelines" script to compute number of lines in a releaes.

19 years agoAdd:
Bruce Momjian [Thu, 22 Sep 2005 21:50:59 +0000 (21:50 +0000)]
Add:

>
>    Another idea would be to allow actual SELECT queries in a COPY.

19 years agopgindent new GIST index code, per request from Tom.
Bruce Momjian [Thu, 22 Sep 2005 20:44:36 +0000 (20:44 +0000)]
pgindent new GIST index code, per request from Tom.

19 years agoAdjust GiST error messages to conform to message style guidelines.
Tom Lane [Thu, 22 Sep 2005 18:49:45 +0000 (18:49 +0000)]
Adjust GiST error messages to conform to message style guidelines.

19 years agoTake exclusive buffer lock in scan_heap() to eliminate some corner cases
Tom Lane [Thu, 22 Sep 2005 17:32:58 +0000 (17:32 +0000)]
Take exclusive buffer lock in scan_heap() to eliminate some corner cases
in which invalid page data could be transiently written to disk by
concurrent bgwriter activity.  There doesn't seem any risk of loss of
actual user data, but an empty page could possibly be left corrupt if a
crash occurs before the correct data gets written out.  Pointed out by
Alvaro Herrera.

19 years agoThis patch cleans up the access to members of ItemIdData.
Bruce Momjian [Thu, 22 Sep 2005 16:46:00 +0000 (16:46 +0000)]
This patch cleans up the access to members of ItemIdData.
It uses existing macros instead of touching directly.

ITAGAKI Takahiro

19 years agoAdd:
Bruce Momjian [Thu, 22 Sep 2005 16:01:59 +0000 (16:01 +0000)]
Add:

>
>  o Allow COPY to output from views
>

19 years agoFix psql \x by removing puts().
Bruce Momjian [Thu, 22 Sep 2005 15:51:51 +0000 (15:51 +0000)]
Fix psql \x by removing puts().

Greg Sabino Mullane

19 years agoSuppress port number for unix domain sockets in log connect/disconnect
Bruce Momjian [Thu, 22 Sep 2005 15:33:36 +0000 (15:33 +0000)]
Suppress port number for unix domain sockets in log connect/disconnect
messages.

19 years agoRemove some dead code.
Tom Lane [Thu, 22 Sep 2005 15:09:51 +0000 (15:09 +0000)]
Remove some dead code.

19 years agoFix postgresql.conf lexer to accept doubled single quotes in literal
Tom Lane [Wed, 21 Sep 2005 20:33:34 +0000 (20:33 +0000)]
Fix postgresql.conf lexer to accept doubled single quotes in literal
strings.  This is consistent with SQL conventions, and since Bruce
already changed initdb in a way that assumed it worked like this, seems
we'd better make it work like this.

19 years agoSuppress database dump item when --table and/or --schema switch was
Tom Lane [Wed, 21 Sep 2005 19:58:02 +0000 (19:58 +0000)]
Suppress database dump item when --table and/or --schema switch was
given, per gripe from Michael Fuhr.

19 years agooptimize_minmax_aggregates() neglected to check for inherited tables.
Tom Lane [Wed, 21 Sep 2005 19:15:27 +0000 (19:15 +0000)]
optimize_minmax_aggregates() neglected to check for inherited tables.
Per report from Cesar Paipilla.

19 years agoFix interaction between psql \set AUTOCOMMIT and "ON_ERROR_ROLLBACK"
Bruce Momjian [Tue, 20 Sep 2005 21:43:08 +0000 (21:43 +0000)]
Fix interaction between psql \set AUTOCOMMIT and "ON_ERROR_ROLLBACK"
by properly updating transaction state after AUTOCOMMIT.

19 years agoMerge items:
Bruce Momjian [Tue, 20 Sep 2005 20:51:30 +0000 (20:51 +0000)]
Merge items:

<   This would be beneficial when there are few distinct values.
>   This would be beneficial when there are few distinct values.  This is
>   already used by GROUP BY.
946d946
< * Allow DISTINCT to use hashing like GROUP BY

19 years agoReturn proper value for psql -f filename failure if filename open fails.
Bruce Momjian [Tue, 20 Sep 2005 18:59:02 +0000 (18:59 +0000)]
Return proper value for psql -f filename failure if filename open fails.

Backpatch to 8.0.X.

19 years agoautovacuum setting false -> off, for consistency
Bruce Momjian [Tue, 20 Sep 2005 02:38:35 +0000 (02:38 +0000)]
autovacuum setting false -> off, for consistency

19 years agoFix typo:
Bruce Momjian [Tue, 20 Sep 2005 02:21:29 +0000 (02:21 +0000)]
Fix typo:

< * Allow WAL traffic to be steamed to another server for stand-by
> * Allow WAL traffic to be streamed to another server for stand-by

19 years agoAdd:
Bruce Momjian [Tue, 20 Sep 2005 02:16:41 +0000 (02:16 +0000)]
Add:

> * Allow DISTINCT to use hashing like GROUP BY

19 years agoUpdate profile file location.
Bruce Momjian [Tue, 20 Sep 2005 01:28:14 +0000 (01:28 +0000)]
Update profile file location.

19 years agoAdd:
Bruce Momjian [Tue, 20 Sep 2005 00:11:00 +0000 (00:11 +0000)]
Add:

> * Allow WAL traffic to be steamed to another server for stand-by
>   replication

19 years agoRemove:
Bruce Momjian [Mon, 19 Sep 2005 22:32:32 +0000 (22:32 +0000)]
Remove:

< * Research use of sched_yield() for spinlock acquisition failure

19 years agoPrint proper cause of statement cancel, user interaction or timeout.
Bruce Momjian [Mon, 19 Sep 2005 17:21:49 +0000 (17:21 +0000)]
Print proper cause of statement cancel, user interaction or timeout.

19 years agoupdate timestamp on file.
Bruce Momjian [Mon, 19 Sep 2005 15:01:28 +0000 (15:01 +0000)]
update timestamp on file.

19 years agoClarify some error messages
Peter Eisentraut [Sun, 18 Sep 2005 09:48:24 +0000 (09:48 +0000)]
Clarify some error messages

19 years agoFix typo in link label, per Evgeny Gridasov.
Tom Lane [Sun, 18 Sep 2005 04:02:05 +0000 (04:02 +0000)]
Fix typo in link label, per Evgeny Gridasov.

19 years agoAdd:
Bruce Momjian [Sat, 17 Sep 2005 12:12:58 +0000 (12:12 +0000)]
Add:

>
1032a1034
> * Remove BeOS and QNX-specific code

19 years agoAdd:
Bruce Momjian [Fri, 16 Sep 2005 19:39:25 +0000 (19:39 +0000)]
Add:

>  o Fix SELECT INTERVAL '1' MONTH

19 years agoAdjust regression for new cancel query message.
Bruce Momjian [Fri, 16 Sep 2005 19:39:02 +0000 (19:39 +0000)]
Adjust regression for new cancel query message.

19 years agoUpdate query cancel message:
Bruce Momjian [Fri, 16 Sep 2005 19:31:04 +0000 (19:31 +0000)]
Update query cancel message:

   errmsg("canceling query due to user request or statement timeout")));

19 years agoAdjust bcc to work for thread changes.
Bruce Momjian [Fri, 16 Sep 2005 19:00:05 +0000 (19:00 +0000)]
Adjust bcc to work for thread changes.

19 years agoThis correction is required of nmake of Windows.
Bruce Momjian [Fri, 16 Sep 2005 18:58:48 +0000 (18:58 +0000)]
This correction is required of nmake of Windows.

Hiroshi Saito

19 years agoUpdate numbering.
Bruce Momjian [Fri, 16 Sep 2005 18:07:35 +0000 (18:07 +0000)]
Update numbering.

Michael Fuhr

19 years agoAdd:
Bruce Momjian [Fri, 16 Sep 2005 17:37:10 +0000 (17:37 +0000)]
Add:

<
> * Update Bonjour to work with newer cross-platform SDK

19 years agotag it all beta2 ... REL8_1_0BETA2
PostgreSQL Daemon [Fri, 16 Sep 2005 17:15:55 +0000 (17:15 +0000)]
tag it all beta2 ...

19 years agoUpdate wording:
Bruce Momjian [Fri, 16 Sep 2005 16:46:09 +0000 (16:46 +0000)]
Update wording:

<
390d388
<
453c451
<    removed or have its heap and index files truncated.  One
>    be removed or have its heap and index files truncated.  One
< * Use a phantom command counter for nested subtransactions to reduce
<   per-tuple overhead

19 years agoSmall fixes
Teodor Sigaev [Fri, 16 Sep 2005 14:40:54 +0000 (14:40 +0000)]
Small fixes

19 years agoAdd:
Bruce Momjian [Fri, 16 Sep 2005 11:24:02 +0000 (11:24 +0000)]
Add:

>  o Add single-step debugging of PL/PgSQL functions

19 years agoRename pg_complete_relation_size() to pg_total_relation_size(), for the
Neil Conway [Fri, 16 Sep 2005 05:35:41 +0000 (05:35 +0000)]
Rename pg_complete_relation_size() to pg_total_relation_size(), for the
sake of brevity and clarity.

Make pg_reload_conf(), pg_rotate_logfile(), and pg_cancel_backend()
return a boolean rather than an integer to indicate success or failure.

Along the way, make some minor cleanups to dbsize.c -- in particular,
use elog() rather than ereport() for "shouldn't happen" error
conditions, and remove some of the more flagrant violations of the
Postgres indentation conventions.

Catalog version bumped.

19 years agoUpdate two comments to refer to use the new list API names.
Neil Conway [Fri, 16 Sep 2005 04:13:18 +0000 (04:13 +0000)]
Update two comments to refer to use the new list API names.

19 years agoUpdate release notes for changes between beta1 and beta2.
Tom Lane [Fri, 16 Sep 2005 03:37:35 +0000 (03:37 +0000)]
Update release notes for changes between beta1 and beta2.

19 years agoAdd note about pg_autovacuum settings not being saved on a dump, per
Alvaro Herrera [Fri, 16 Sep 2005 03:12:32 +0000 (03:12 +0000)]
Add note about pg_autovacuum settings not being saved on a dump, per
Robert Treat.

19 years agoForce the size and alignment of LWLock array entries to be either 16 or 32
Tom Lane [Fri, 16 Sep 2005 00:30:05 +0000 (00:30 +0000)]
Force the size and alignment of LWLock array entries to be either 16 or 32
bytes.  This shouldn't make any difference on x86 machines, where the size
happened to be 16 bytes anyway, but on 64-bit machines and machines with
slock_t int or wider, it will speed array indexing and hopefully reduce
SMP cache contention effects.  Per recent experimentation.

19 years agoCopy-editing for GiST README.
Neil Conway [Thu, 15 Sep 2005 17:44:27 +0000 (17:44 +0000)]
Copy-editing for GiST README.

19 years agoReadme about GiST's algorithms
Teodor Sigaev [Thu, 15 Sep 2005 16:39:15 +0000 (16:39 +0000)]
Readme about GiST's algorithms

19 years ago1 Update Snowball sources
Teodor Sigaev [Thu, 15 Sep 2005 11:14:18 +0000 (11:14 +0000)]
1 Update Snowball sources
2 Makefile fixes

19 years agoVarious documentation improvements. Add a lot of index entries for
Neil Conway [Wed, 14 Sep 2005 21:14:26 +0000 (21:14 +0000)]
Various documentation improvements. Add a lot of index entries for
the builtin functions (although some more entries are still needed),
and remove the duplicate index entries that have been causing
collateindex.pl warnings. Consistently use "int" and "bigint", rather
than a mix of "int", "integer", "int4", "bigint", and "int8". Make
parenthesis style in syntax examples more consistent. Various
copy-editing for newly-added documentation and SGML markup fixes.

19 years agoTweak the PL/PgSQL regression tests to catch the recently reported bug
Neil Conway [Wed, 14 Sep 2005 18:35:38 +0000 (18:35 +0000)]
Tweak the PL/PgSQL regression tests to catch the recently reported bug
in parsing cursor declarations.

19 years agoFix recent breakage of decl_cursor_arglist syntax, per Michael Paesold.
Tom Lane [Wed, 14 Sep 2005 13:46:47 +0000 (13:46 +0000)]
Fix recent breakage of decl_cursor_arglist syntax, per Michael Paesold.

19 years agoFix make_tuple_from_row to support nested rowtypes, per gripe from
Tom Lane [Tue, 13 Sep 2005 16:16:17 +0000 (16:16 +0000)]
Fix make_tuple_from_row to support nested rowtypes, per gripe from
Roman Neuhauser.  Update some obsolete comments for exec_eval_datum, too.

19 years agoMinor SGML markup fixes.
Neil Conway [Tue, 13 Sep 2005 15:24:57 +0000 (15:24 +0000)]
Minor SGML markup fixes.

19 years agoDocument the new autovacuum daemon.
Alvaro Herrera [Tue, 13 Sep 2005 01:51:18 +0000 (01:51 +0000)]
Document the new autovacuum daemon.

19 years agoFix cut-and-paste-o in TCP keepalives documentation.
Tom Lane [Mon, 12 Sep 2005 23:09:05 +0000 (23:09 +0000)]
Fix cut-and-paste-o in TCP keepalives documentation.

19 years agoMinor documentation tweak: make the capitalization of a section title
Neil Conway [Mon, 12 Sep 2005 22:39:30 +0000 (22:39 +0000)]
Minor documentation tweak: make the capitalization of a section title
consistent with the other sections in this chapter.

19 years agoEnsure that any memory leaked during an error inside the bgwriter is
Tom Lane [Mon, 12 Sep 2005 22:20:16 +0000 (22:20 +0000)]
Ensure that any memory leaked during an error inside the bgwriter is
recovered.  I did not see any actual leak while testing this in CVS tip,
but 8.0 definitely has a problem with leaking the space temporarily
palloc'd by BufferSync().  In any case this seems a good idea to forestall
similar problems in future.  Per report from Arjen van der Meijden.

19 years agoMake the documentation of GUC variables a separate chapter, rather than
Neil Conway [Mon, 12 Sep 2005 22:11:38 +0000 (22:11 +0000)]
Make the documentation of GUC variables a separate chapter, rather than
a section of the "Server Run-time Environment" chapter. Also, move the
SGML for the new chapter to a separate file and fix the resulting
fallout.

19 years agoUpdate manual's introduction to indexes to reflect 8.1 changes; in
Tom Lane [Mon, 12 Sep 2005 19:17:45 +0000 (19:17 +0000)]
Update manual's introduction to indexes to reflect 8.1 changes; in
particular the addition of bitmap scans and the relaxation of rules
about when multicolumn indexes can be used.  Also some minor editorial
work in other parts of the chapter.

19 years agoFix a mistake in the documentation for SPI_getbinval(), per Michael Fuhr.
Neil Conway [Mon, 12 Sep 2005 18:40:19 +0000 (18:40 +0000)]
Fix a mistake in the documentation for SPI_getbinval(), per Michael Fuhr.

19 years agoForgot to add pg_pltemplate to the list of shared system catalogs that
Tom Lane [Mon, 12 Sep 2005 16:43:29 +0000 (16:43 +0000)]
Forgot to add pg_pltemplate to the list of shared system catalogs that
appears in the REINDEX ref page.

19 years agoFixed transaction command handling to not ignore savepoints and to correctly check...
Michael Meskes [Mon, 12 Sep 2005 11:57:53 +0000 (11:57 +0000)]
Fixed transaction command handling to not ignore savepoints and to correctly check for errors.

19 years agoAdd a few items to the release notes, and make a few more minor cleanups.
Neil Conway [Mon, 12 Sep 2005 05:10:12 +0000 (05:10 +0000)]
Add a few items to the release notes, and make a few more minor cleanups.

19 years agoTweak TCP-keepalive code so that an invalid setting doesn't cause us
Tom Lane [Mon, 12 Sep 2005 02:26:33 +0000 (02:26 +0000)]
Tweak TCP-keepalive code so that an invalid setting doesn't cause us
to drop connections unceremoniously.  Also some other marginal cleanups:
don't query getsockopt() repeatedly if it fails, and avoid having the
apparent definition of struct Port depend on which system headers you
might have included or not.  Oliver Jowett and Tom Lane.

19 years agoMany small improvements and copy edits to the release notes. Use "&mdash;"
Neil Conway [Sun, 11 Sep 2005 23:40:33 +0000 (23:40 +0000)]
Many small improvements and copy edits to the release notes. Use "&mdash;"
rather than "-" for the "dash" character. Correct SGML markup. Make
references to the names of contributors more consistent. Rewrite a bit
of prose, and make some other similar cleanups.

19 years agoFix some corner-case bugs in _sendSQLLine's parsing of SQL commands
Tom Lane [Sun, 11 Sep 2005 04:10:25 +0000 (04:10 +0000)]
Fix some corner-case bugs in _sendSQLLine's parsing of SQL commands
> found in a pg_dump archive.  It had problems with dollar-quote tags
broken across bufferload boundaries (this may explain bug report from
Rod Taylor), also with dollar-quote literals of the form $a$a$...,
and was also confused about the rules for backslash in double quoted
identifiers (ie, they're not special).  Also put in placeholder support
for E'...' literals --- this will need more work later.

19 years agoAvoid changing stdin/stdout to binary mode on Windows unless that is
Tom Lane [Sun, 11 Sep 2005 00:36:14 +0000 (00:36 +0000)]
Avoid changing stdin/stdout to binary mode on Windows unless that is
really the source or destination of the archive.  I think this will
resolve recent complaints that password prompting is broken in pg_restore
on Windows.  Note that password prompting and reading from stdin is an
unworkable combination on Windows ... but that was true anyway.

19 years agoUpdate URL for FAQ_MINGW.
Bruce Momjian [Sat, 10 Sep 2005 05:21:52 +0000 (05:21 +0000)]
Update URL for FAQ_MINGW.

19 years agoGiven its current definition that depends on time(NULL), timetz_zone
Tom Lane [Fri, 9 Sep 2005 06:51:12 +0000 (06:51 +0000)]
Given its current definition that depends on time(NULL), timetz_zone
is certainly no longer immutable, but must indeed be marked volatile.
I wonder if it should use the value of now() (that is, transaction
start time) so that it could be marked stable.  But it's probably not
important enough to be worth changing the code for ... indeed, I'm not
even going to force an initdb for this catalog change, seeing that we
just did one a few hours ago.

19 years agotimestamptz_izone should return the input, not NULL, when the input
Tom Lane [Fri, 9 Sep 2005 06:46:14 +0000 (06:46 +0000)]
timestamptz_izone should return the input, not NULL, when the input
is a non-finite timestamp, for consistency with related functions.
In other words: +infinity rotated to a different timezone is still
+infinity.

19 years agoFix the various forms of AT TIME ZONE to accept either timezones found
Tom Lane [Fri, 9 Sep 2005 02:31:50 +0000 (02:31 +0000)]
Fix the various forms of AT TIME ZONE to accept either timezones found
in the zic database or zone names found in the date token table.  This
preserves the old ability to do AT TIME ZONE 'PST' along with the new
ability to do AT TIME ZONE 'PST8PDT'.  Per gripe from Bricklen Anderson.
Also, fix some inconsistencies in usage of TZ_STRLEN_MAX --- the old
code had the potential for one-byte buffer overruns, though given
alignment considerations it's unlikely there was any real risk.

19 years agoCreate the pg_pltemplate system catalog to hold template information
Tom Lane [Thu, 8 Sep 2005 20:07:42 +0000 (20:07 +0000)]
Create the pg_pltemplate system catalog to hold template information
for procedural languages.  This replaces the hard-wired table I had
originally proposed as a stopgap solution.  For the moment, the initial
contents only include languages shipped with the core distribution.

19 years agoUpdate regression tests for new USA timezone data. Mea culpa for not
Tom Lane [Thu, 8 Sep 2005 16:49:04 +0000 (16:49 +0000)]
Update regression tests for new USA timezone data.  Mea culpa for not
realizing that the regression tests could be affected.

19 years agoUpdate timezone data files to release 2005m of the zic database.
Tom Lane [Wed, 7 Sep 2005 21:39:25 +0000 (21:39 +0000)]
Update timezone data files to release 2005m of the zic database.
Among other changes, this reflects the recently passed change in USA
daylight savings rules.

19 years agoImplement a preliminary 'template' facility for procedural languages,
Tom Lane [Mon, 5 Sep 2005 23:50:49 +0000 (23:50 +0000)]
Implement a preliminary 'template' facility for procedural languages,
as per my recent proposal.  For now the template data is hard-wired in
proclang.c --- this should be replaced later by a new shared system
catalog, but we don't want to force initdb during 8.1 beta.  This change
lets us cleanly load existing dump files even if they contain outright
wrong information about a PL's support functions, such as a wrong path
to the shared library or a missing validator function.  Also, we can
revert the recent kluges to make pg_dump dump PL support functions that
are stored in pg_catalog.
While at it, I removed the code in pg_regress that replaced $libdir
with a hardcoded path for temporary installations.  This is no longer
needed given our support for relocatable installations.

19 years agoBack out prior patch and instead just suppress SubqueryScan elimination
Tom Lane [Mon, 5 Sep 2005 18:59:38 +0000 (18:59 +0000)]
Back out prior patch and instead just suppress SubqueryScan elimination
when there are extra resjunk columns in the child node.  I found some
additional cases involving Append nodes that weren't handled by the
prior patch, and it's not clear how to fix them in the same way without
breaking inheritance cases.  So the prudent path seems to be to narrow
the scope of the optimization.

19 years agoClean up version comparison/display code, per gripe from Michael Fuhr.
Tom Lane [Mon, 5 Sep 2005 18:05:13 +0000 (18:05 +0000)]
Clean up version comparison/display code, per gripe from Michael Fuhr.

19 years agoFor non-projecting plan node types such as Limit, set_plan_references
Tom Lane [Mon, 5 Sep 2005 17:25:01 +0000 (17:25 +0000)]
For non-projecting plan node types such as Limit, set_plan_references
has to recopy the input plan node's targetlist if it removes a
SubqueryScan node just below the non-projecting node.  For simplicity
I made it recopy always.  Per bug report from Allan Wang and Michael Fuhr.

19 years agoAdd a note about CSV lines with trailing spaces.
Andrew Dunstan [Mon, 5 Sep 2005 14:44:05 +0000 (14:44 +0000)]
Add a note about CSV lines with trailing spaces.
Suggestion by Darcy Buskermolen, reworded by me.

19 years agoConditionally output the server version number in psql if it doesn't
Bruce Momjian [Mon, 5 Sep 2005 13:59:08 +0000 (13:59 +0000)]
Conditionally output the server version number in psql if it doesn't
exactly match the client version number, and warn about major version
mismatches.