[COMMITTERS] pgsql: Reduce WAL activity for page splits: > Currently, an index split

2007-02-07 Thread Bruce Momjian
Log Message: --- Reduce WAL activity for page splits: > Currently, an index split writes all the data on the split page to > WAL. That's a lot of WAL traffic. The tuples that are copied to the > right page need to be WAL logged, but the tuples that stay on the > original page don't. Heikk

[COMMITTERS] pgsql: Check if the role exists before doing more complex ident and

2007-02-07 Thread Bruce Momjian
Log Message: --- Check if the role exists before doing more complex ident and Kerberos authentication checks in the backend. Gavin Sherry Modified Files: -- pgsql/src/backend/libpq: auth.c (r1.147 -> r1.148) (http://developer.postgresql.org/cvsweb.cgi/pgsq

[COMMITTERS] pgsql: Update URL for "Generalized Partial Indexes" paper to point to a

2007-02-07 Thread Bruce Momjian
Log Message: --- Update URL for "Generalized Partial Indexes" paper to point to a cached version. Backpatch to 8.2.X. Modified Files: -- pgsql/doc/src/sgml: biblio.sgml (r1.26 -> r1.27) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/biblio.

[COMMITTERS] pgsql: Update URL for "Generalized Partial Indexes" paper to point to a

2007-02-07 Thread Bruce Momjian
Log Message: --- Update URL for "Generalized Partial Indexes" paper to point to a cached version. Backpatch to 8.2.X. Tags: REL8_2_STABLE Modified Files: -- pgsql/doc/src/sgml: biblio.sgml (r1.26 -> r1.26.2.1) (http://developer.postgresql.org/cvsweb.

[COMMITTERS] pgsql: Document that wal_sync_method open_* methods use O_DIRECT, if

2007-02-07 Thread Bruce Momjian
Log Message: --- Document that wal_sync_method open_* methods use O_DIRECT, if available. Backpatch to 8.2.X. Tags: REL8_2_STABLE Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.98.2.2 -> r1.98.2.3) (http://developer.postgresql.org/cvsweb.cgi/

[COMMITTERS] pgsql: Document that wal_sync_method open_* methods use O_DIRECT, if

2007-02-07 Thread Bruce Momjian
Log Message: --- Document that wal_sync_method open_* methods use O_DIRECT, if available. Backpatch to 8.2.X. Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.108 -> r1.109) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml.d

[COMMITTERS] pgsql: Fix bug in our code when using to_timestamp() or to_date()

2007-02-07 Thread Bruce Momjian
Log Message: --- Fix bug in our code when using to_timestamp() or to_date() without "TM". Assume "TM" when input fields are variable-length, like month or day names. This matches Oracle behavior. Modified Files: -- pgsql/src/backend/utils/adt: formatting.c (r1.118

[COMMITTERS] pgsql: Add a function pg_stat_clear_snapshot() that discards any

2007-02-07 Thread Tom Lane
Log Message: --- Add a function pg_stat_clear_snapshot() that discards any statistics snapshot already collected in the current transaction; this allows plpgsql functions to watch for stats updates even though they are confined to a single transaction. Use this instead of the previous kluge

[COMMITTERS] pgsql: Modify the stats regression test to delay until the stats file

2007-02-07 Thread Tom Lane
Log Message: --- Modify the stats regression test to delay until the stats file actually changes (with an upper limit of 30 seconds), and record the delay time in the postmaster log. This should give us some info about what's happening with the intermittent stats failures in buildfarm. Af

[COMMITTERS] pgsql: Remove the xlog-centric "database system is ready" message and

2007-02-07 Thread Tom Lane
Log Message: --- Remove the xlog-centric "database system is ready" message and replace it with "database system is ready to accept connections", which is issued by the postmaster when it really is ready to accept connections. Per proposal from Markus Schiltknecht and subsequent discussion

Re: [COMMITTERS] pgsql: Stamp releases notes for 8.2.3, 8.1.8, 8.0.12.

2007-02-07 Thread Andrew Dunstan
Bruce Momjian wrote: Andrew Dunstan wrote: Bruce Momjian wrote: Log Message: --- Stamp releases notes for 8.2.3, 8.1.8, 8.0.12. Tags: REL8_2_STABLE This missed the fix for psql "\copy (query)" which I committed the other day for 8.2, and should probably have be

Re: [COMMITTERS] pgsql: Stamp releases notes for 8.2.3, 8.1.8, 8.0.12.

2007-02-07 Thread Bruce Momjian
Andrew Dunstan wrote: > Bruce Momjian wrote: > > Log Message: > > --- > > Stamp releases notes for 8.2.3, 8.1.8, 8.0.12. > > > > Tags: > > > > REL8_2_STABLE > > > > > > This missed the fix for psql "\copy (query)" which I committed the other > day for 8.2, and should probably have

Re: [COMMITTERS] pgsql: Stamp releases notes for 8.2.3, 8.1.8, 8.0.12.

2007-02-07 Thread Andrew Dunstan
Bruce Momjian wrote: Log Message: --- Stamp releases notes for 8.2.3, 8.1.8, 8.0.12. Tags: REL8_2_STABLE This missed the fix for psql "\copy (query)" which I committed the other day for 8.2, and should probably have been in the release notes. What's the protocol there? che

Re: [COMMITTERS] Help Needed

2007-02-07 Thread Andrew Dunstan
Muruganantham M wrote: Hi, We are developing one website using ChessD in red hat environment. ChessD is a open source which requires Postgres as its back end. When we tried to install ChessD we got the error Missing postgresql/libpq-fe.h, is libpq-dev installed?. But this chess D is works

[COMMITTERS] Help Needed

2007-02-07 Thread Muruganantham M
Hi, We are developing one website using ChessD in red hat environment. ChessD is a open source which requires Postgres as its back end. When we tried to install ChessD we got the error Missing postgresql/libpq-fe.h, is libpq-dev installed?. But this chess D is works fine in Debian and We need a

[COMMITTERS] pginstaller - pginst: Update for PostGIS JDBC 1.7

2007-02-07 Thread User Dpage
Log Message: --- Update for PostGIS JDBC 1.7 Tags: REL8_2_STABLE Modified Files: -- pginst/wxs: pginst.wxs (r1.182 -> r1.182.2.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/wxs/pginst.wxs.diff?r1=1.182&r2=1.182.2.1) -

[COMMITTERS] pgsql: The VC++ build needs to compile the new strlcat.c file.

2007-02-07 Thread Alvaro Herrera
Log Message: --- The VC++ build needs to compile the new strlcat.c file. Patch from Magnus Hagander. Modified Files: -- pgsql/src/tools/msvc: mkvcbuild.pl (r1.12 -> r1.13) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/tools/msvc/mkvcbuild.pl.diff?r

[COMMITTERS] pginstaller - pginst: Prep for 8.2.3

2007-02-07 Thread User Dpage
Log Message: --- Prep for 8.2.3 Tags: REL8_2_STABLE Modified Files: -- pginst/package: README.TXT (r1.4.2.2 -> r1.4.2.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/package/README.TXT.diff?r1=1.4.2.2&r2=1.4.2.3) --

[COMMITTERS] pginstaller - pginst: Prep for 8.1.8

2007-02-07 Thread User Dpage
Log Message: --- Prep for 8.1.8 Tags: REL8_1_STABLE Modified Files: -- pginst/package: README.TXT (r1.1.4.10 -> r1.1.4.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/package/README.TXT.diff?r1=1.1.4.10&r2=1.1.4.11) --

[COMMITTERS] pginstaller - pginst: Prep for 8.0.12

2007-02-07 Thread User Dpage
Log Message: --- Prep for 8.0.12 Tags: REL8_0_STABLE Modified Files: -- pginst/package: README.TXT (r1.1.2.11 -> r1.1.2.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/package/README.TXT.diff?r1=1.1.2.11&r2=1.1.2.12) upgrad