OSDN Git Service
Bruce Momjian [Mon, 3 Oct 2005 02:21:16 +0000 (02:21 +0000)]
Merge Tom and my descriptions of new sequence behavior into one entry.
Bruce Momjian [Mon, 3 Oct 2005 01:57:59 +0000 (01:57 +0000)]
Update release notes to show how to upgrade a database to use the new
early binding for nextval() calls in default clauses.
Bruce Momjian [Mon, 3 Oct 2005 00:42:57 +0000 (00:42 +0000)]
Remove, 8.1 completed items already removed:
< * -Have sequence dependency track use of DEFAULT sequences
Bruce Momjian [Mon, 3 Oct 2005 00:42:28 +0000 (00:42 +0000)]
Done:
< * Have sequence dependency track use of DEFAULT sequences,
< seqname.nextval?
> * -Have sequence dependency track use of DEFAULT sequences
Tom Lane [Mon, 3 Oct 2005 00:28:43 +0000 (00:28 +0000)]
Expand pg_control information so that we can verify that the database
was created on a machine with alignment rules and floating-point format
similar to the current machine. Per recent discussion, this seems like
a good idea with the increasing prevalence of 32/64 bit environments.
Tom Lane [Sun, 2 Oct 2005 23:50:16 +0000 (23:50 +0000)]
Change nextval and other sequence functions to specify their sequence
argument as a 'regclass' value instead of a text string. The frontend
conversion of text string to pg_class OID is now encapsulated as an
implicitly-invocable coercion from text to regclass. This provides
backwards compatibility to the old behavior when the sequence argument
is explicitly typed as 'text'. When the argument is just an unadorned
literal string, it will be taken as 'regclass', which means that the
stored representation will be an OID. This solves longstanding problems
with renaming sequences that are referenced in default expressions, as
well as new-in-8.1 problems with renaming such sequences' schemas or
moving them to another schema. All per recent discussion.
Along the way, fix some rather serious problems in dbmirror's support
for mirroring sequence operations (int4 vs int8 confusion for instance).
Tom Lane [Sat, 1 Oct 2005 18:43:19 +0000 (18:43 +0000)]
_SPI_execute_plan failed to return result tuple table to caller in
the ProcessUtility case, resulting in an intratransaction memory leak
if a utility command actually did return any tuples, as reported by
Dmitry Karasik. Fix this and also make the behavior more consistent
for cases involving nested SPI operations and multiple query trees,
by ensuring that we store the state locally until it is ready to be
returned to the caller.
Bruce Momjian [Sat, 1 Oct 2005 01:42:43 +0000 (01:42 +0000)]
Adjust wording.
Bruce Momjian [Fri, 30 Sep 2005 22:38:44 +0000 (22:38 +0000)]
One of the web pages mentioned in dmetaphone.c has moved. Also fix
a few typos in comments.
The dictionaries I checked list "altho" as a variant of "although,"
but I didn't find any other instances of the former in the source
tree so I changed it.
Michael Fuhr
Peter Eisentraut [Fri, 30 Sep 2005 09:56:26 +0000 (09:56 +0000)]
Equalize wordings to avoid redundant translation work.
Peter Eisentraut [Fri, 30 Sep 2005 07:58:01 +0000 (07:58 +0000)]
Clean up the help displays.
Peter Eisentraut [Fri, 30 Sep 2005 07:13:54 +0000 (07:13 +0000)]
Change the option spelling to --connection-limit to be consistent with the
SQL option spelling.
Alvaro Herrera [Thu, 29 Sep 2005 22:04:36 +0000 (22:04 +0000)]
Fix confusion between relfilenode and Oid.
Also, make pg_total_relation_size include the size of the
TOAST index.
Tom Lane [Thu, 29 Sep 2005 16:18:26 +0000 (16:18 +0000)]
Fix unportable usages in new pgbench code (strndup, ctype macros)
Tatsuo Ishii [Thu, 29 Sep 2005 13:44:25 +0000 (13:44 +0000)]
Add -f option which enables to read SQL commands from a file.
Patches Contributed by Tomoaki Sato.
Peter Eisentraut [Thu, 29 Sep 2005 08:34:50 +0000 (08:34 +0000)]
Correct spelling
Bruce Momjian [Thu, 29 Sep 2005 02:29:48 +0000 (02:29 +0000)]
Remove acronym in one title.
Tom Lane [Wed, 28 Sep 2005 21:22:12 +0000 (21:22 +0000)]
Mention fix for bug #1916 in release notes for affected versions.
Tom Lane [Wed, 28 Sep 2005 21:17:02 +0000 (21:17 +0000)]
Repair planning bug introduced in 7.4: outer-join ON clauses that referenced
only the inner-side relation would be considered as potential equijoin clauses,
which is wrong because the condition doesn't necessarily hold above the point
of the outer join. Per test case from Kevin Grittner (bug#1916).
Bruce Momjian [Wed, 28 Sep 2005 18:40:28 +0000 (18:40 +0000)]
Fix typo.
Bruce Momjian [Wed, 28 Sep 2005 18:18:02 +0000 (18:18 +0000)]
Add section on reliable operation, talking about caching and storage
subsystem reliability.
Peter Eisentraut [Wed, 28 Sep 2005 13:11:26 +0000 (13:11 +0000)]
Improve messages
Bruce Momjian [Wed, 28 Sep 2005 11:45:52 +0000 (11:45 +0000)]
Update SQL conformance mention to 2003.
Bruce Momjian [Wed, 28 Sep 2005 11:32:49 +0000 (11:32 +0000)]
Update Russian FAQ.
Victor Vislobokov
Bruce Momjian [Tue, 27 Sep 2005 23:32:38 +0000 (23:32 +0000)]
Add attribution.
Bruce Momjian [Tue, 27 Sep 2005 18:04:34 +0000 (18:04 +0000)]
Done:
< * +Add options to pg_config to show the share_dir, sysconfdir,
< pkgincludedir, and localedir
Tom Lane [Tue, 27 Sep 2005 17:43:31 +0000 (17:43 +0000)]
Some marginal tweaks to make 'make installcheck' mostly work when
building contrib with USE_PGXS. To make it work all the way, the
pg_regress script would need to be included in the installation tree.
Tom Lane [Tue, 27 Sep 2005 17:39:35 +0000 (17:39 +0000)]
Fix problems with PGXS builds against an installation tree that was
relocated after installation. We can't trust the installation paths
inserted into Makefile.global by configure, so instead we must get the
paths from pg_config. This requires extending pg_config to support all
the separately-configurable path names, but that was on TODO anyway.
Bruce Momjian [Tue, 27 Sep 2005 17:28:51 +0000 (17:28 +0000)]
Release notes up to date as of today.
Bruce Momjian [Tue, 27 Sep 2005 17:16:08 +0000 (17:16 +0000)]
Suppress FAQ and TODO changes in pgcvslog output.
Tom Lane [Tue, 27 Sep 2005 17:13:14 +0000 (17:13 +0000)]
PGXS should be set with := not =, as specified in the documentation,
to avoid useless multiple executions of pg_config.
Bruce Momjian [Tue, 27 Sep 2005 16:30:25 +0000 (16:30 +0000)]
Fix incorrect psql \x memory allocation for numericlocale. Redesign API
to be less error-prone.
Bruce Momjian [Tue, 27 Sep 2005 15:18:13 +0000 (15:18 +0000)]
Add:
> o Improve signal handling,
> http://archives.postgresql.org/pgsql-patches/2005-06/msg00027.php
Bruce Momjian [Tue, 27 Sep 2005 13:39:32 +0000 (13:39 +0000)]
Novice:
< * Add options to pg_config to show the share_dir, sysconfdir,
> * +Add options to pg_config to show the share_dir, sysconfdir,
Tom Lane [Tue, 27 Sep 2005 04:53:23 +0000 (04:53 +0000)]
Fix our version of strdup() to adhere to the standard semantics for
out-of-memory --- that is, return NULL rather than dumping core.
Noted by Qingqing Zhou.
Tom Lane [Mon, 26 Sep 2005 21:44:04 +0000 (21:44 +0000)]
Create preliminary release notes for upcoming back-branch releases.
Bruce Momjian [Mon, 26 Sep 2005 18:09:57 +0000 (18:09 +0000)]
Rename variable for clarity.
Peter Eisentraut [Mon, 26 Sep 2005 17:49:09 +0000 (17:49 +0000)]
Don't need gettext calls around debug messages.
Bruce Momjian [Mon, 26 Sep 2005 16:48:28 +0000 (16:48 +0000)]
Prevent threaded python build on BSD's, where it fails.
Marko Kreen
Bruce Momjian [Mon, 26 Sep 2005 15:52:35 +0000 (15:52 +0000)]
Done:
< * Allow protocol-level EXECUTE that is actually a fetch to appear
< in the logs as a fetch rather than another execute
Bruce Momjian [Mon, 26 Sep 2005 15:51:12 +0000 (15:51 +0000)]
Log protocol-excute fetch operatation as fetch, rather than execute,
adjusted from a patch by Simon.
Bruce Momjian [Mon, 26 Sep 2005 02:44:28 +0000 (02:44 +0000)]
Add:
> * Allow protocol-level BIND parameter values to be logged
> * Allow protocol-level EXECUTE that is actually a fetch to appear
> in the logs as a fetch rather than another execute
Tom Lane [Sun, 25 Sep 2005 19:37:35 +0000 (19:37 +0000)]
The original patch to avoid building a hash join's hashtable when the
outer relation is empty did not work, per test case from Patrick Welche.
It tried to use nodeHashjoin.c's high-level mechanisms for fetching an
outer-relation tuple, but that code expected the hash table to be filled
already. As patched, the code failed in corner cases such as having no
outer-relation tuples for the first hash batch. Revert and rewrite.
Bruce Momjian [Sun, 25 Sep 2005 03:12:13 +0000 (03:12 +0000)]
Wording cleanup.
Bruce Momjian [Sun, 25 Sep 2005 03:06:41 +0000 (03:06 +0000)]
Document why PQtrace and ecpg debug() can crash the application if the
DLL compiles to not match the application.
Neil Conway [Sat, 24 Sep 2005 23:25:31 +0000 (23:25 +0000)]
Cleanups for recent addition to log_connections documentation.
Bruce Momjian [Sat, 24 Sep 2005 23:08:07 +0000 (23:08 +0000)]
Improve wording.
Tom Lane [Sat, 24 Sep 2005 23:07:18 +0000 (23:07 +0000)]
Clean up possibly-uninitialized-variable warnings reported by gcc 4.x.
Bruce Momjian [Sat, 24 Sep 2005 23:06:24 +0000 (23:06 +0000)]
Add mention of duplicate connection messages from psql, per Andrew.
Bruce Momjian [Sat, 24 Sep 2005 22:57:15 +0000 (22:57 +0000)]
Update release notes for 4-byte UTF mappings.
Tom Lane [Sat, 24 Sep 2005 22:54:44 +0000 (22:54 +0000)]
Clean up possibly-uninitialized-variable warnings reported by gcc 4.x.
Tom Lane [Sat, 24 Sep 2005 20:35:21 +0000 (20:35 +0000)]
Document change in large object snapshotting behavior as a version
compatibility issue.
Tom Lane [Sat, 24 Sep 2005 19:14:05 +0000 (19:14 +0000)]
Suppress signed-vs-unsigned-char warnings in contrib.
Tom Lane [Sat, 24 Sep 2005 17:53:28 +0000 (17:53 +0000)]
Suppress signed-vs-unsigned-char warnings.
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.
Bruce Momjian [Fri, 23 Sep 2005 22:25:25 +0000 (22:25 +0000)]
Add comments explaining clauses used by CREATE ROLE but not ALTER.
Bruce Momjian [Fri, 23 Sep 2005 21:55:01 +0000 (21:55 +0000)]
Add:
> * Simplify dropping roles that have objects in several databases
Bruce Momjian [Fri, 23 Sep 2005 20:41:39 +0000 (20:41 +0000)]
Add:
> o Allow PL/PgSQL to support WITH HOLD cursors
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.
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.
Tom Lane [Fri, 23 Sep 2005 15:36:57 +0000 (15:36 +0000)]
Fix typo in comment.
Tom Lane [Fri, 23 Sep 2005 15:05:04 +0000 (15:05 +0000)]
Document that chkpass ignores password characters after the eighth.
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
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
>
Bruce Momjian [Fri, 23 Sep 2005 02:42:34 +0000 (02:42 +0000)]
Clarify autovacuum wording.
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
Bruce Momjian [Fri, 23 Sep 2005 02:06:58 +0000 (02:06 +0000)]
Mention that autovacuum also needs stats.
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.]
Bruce Momjian [Thu, 22 Sep 2005 23:56:46 +0000 (23:56 +0000)]
Add warning about DOMAINs.
David Fetter
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
>
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.
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.
Bruce Momjian [Thu, 22 Sep 2005 23:24:58 +0000 (23:24 +0000)]
Add "basic" for table partitioning.
Bruce Momjian [Thu, 22 Sep 2005 21:59:50 +0000 (21:59 +0000)]
Add instructions.
Bruce Momjian [Thu, 22 Sep 2005 21:58:58 +0000 (21:58 +0000)]
Add "codelines" script to compute number of lines in a releaes.
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.
Bruce Momjian [Thu, 22 Sep 2005 20:44:36 +0000 (20:44 +0000)]
pgindent new GIST index code, per request from Tom.
Tom Lane [Thu, 22 Sep 2005 18:49:45 +0000 (18:49 +0000)]
Adjust GiST error messages to conform to message style guidelines.
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.
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
Bruce Momjian [Thu, 22 Sep 2005 16:01:59 +0000 (16:01 +0000)]
Add:
>
> o Allow COPY to output from views
>
Bruce Momjian [Thu, 22 Sep 2005 15:51:51 +0000 (15:51 +0000)]
Fix psql \x by removing puts().
Greg Sabino Mullane
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.
Tom Lane [Thu, 22 Sep 2005 15:09:51 +0000 (15:09 +0000)]
Remove some dead code.
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.
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.
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.
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.
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
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.
Bruce Momjian [Tue, 20 Sep 2005 02:38:35 +0000 (02:38 +0000)]
autovacuum setting false -> off, for consistency
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
Bruce Momjian [Tue, 20 Sep 2005 02:16:41 +0000 (02:16 +0000)]
Add:
> * Allow DISTINCT to use hashing like GROUP BY
Bruce Momjian [Tue, 20 Sep 2005 01:28:14 +0000 (01:28 +0000)]
Update profile file location.
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
Bruce Momjian [Mon, 19 Sep 2005 22:32:32 +0000 (22:32 +0000)]
Remove:
< * Research use of sched_yield() for spinlock acquisition failure
Bruce Momjian [Mon, 19 Sep 2005 17:21:49 +0000 (17:21 +0000)]
Print proper cause of statement cancel, user interaction or timeout.
Bruce Momjian [Mon, 19 Sep 2005 15:01:28 +0000 (15:01 +0000)]
update timestamp on file.
Peter Eisentraut [Sun, 18 Sep 2005 09:48:24 +0000 (09:48 +0000)]
Clarify some error messages
Tom Lane [Sun, 18 Sep 2005 04:02:05 +0000 (04:02 +0000)]
Fix typo in link label, per Evgeny Gridasov.