[COMMITTERS] pgsql: Add URL for: * Do async I/O for faster random read-ahead of data

2008-03-12 Thread Bruce Momjian
Log Message: --- Add URL for: * Do async I/O for faster random read-ahead of data Async I/O allows multiple I/O requests to be sent to the disk with results coming back asynchronously. > http://archives.postgresql.org/pgsql-performance/2007-09/msg00255.php Modified Files:

[COMMITTERS] pgsql: Fix pg_plan_queries() to restore the previous setting of

2008-03-12 Thread Tom Lane
Log Message: --- Fix pg_plan_queries() to restore the previous setting of ActiveSnapshot (probably NULL) before exiting. Up to now it's just left the variable as it set it, which means that after we're done processing the current client message, ActiveSnapshot is probably pointing at garba

[COMMITTERS] pgsql: Fix pg_plan_queries() to restore the previous setting of

2008-03-12 Thread Tom Lane
Log Message: --- Fix pg_plan_queries() to restore the previous setting of ActiveSnapshot (probably NULL) before exiting. Up to now it's just left the variable as it set it, which means that after we're done processing the current client message, ActiveSnapshot is probably pointing at garba

[COMMITTERS] pgsql: Add psql TODO: < * Include the symbolic SQLSTATE name in verbose

2008-03-12 Thread Bruce Momjian
Log Message: --- Add psql TODO: < * Include the symbolic SQLSTATE name in verbose error reports < < http://archives.postgresql.org/pgsql-general/2007-09/msg00438.php Modified Files: -- pgsql/doc: TODO (r1.2327 -> r1.2328) (http://anoncvs.postgresql.org/

[COMMITTERS] pgsql: Add to TODO: > * Expire published xmin for read-only and idle

2008-03-12 Thread Bruce Momjian
Log Message: --- Add to TODO: > * Expire published xmin for read-only and idle transactions > > http://archives.postgresql.org/pgsql-hackers/2007-09/msg00343.php Modified Files: -- pgsql/doc: TODO (r1.2326 -> r1.2327) (http://anoncvs.postgresql.org/cvsw

[COMMITTERS] pgsql: Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by

2008-03-12 Thread Tom Lane
Log Message: --- Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by postponing pg_listener modifications commanded by LISTEN and UNLISTEN until the end of the current transaction. This allows us to hold the ExclusiveLock on pg_listener until after commit, with no greater risk o

[COMMITTERS] pgsql: Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by

2008-03-12 Thread Tom Lane
Log Message: --- Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by postponing pg_listener modifications commanded by LISTEN and UNLISTEN until the end of the current transaction. This allows us to hold the ExclusiveLock on pg_listener until after commit, with no greater risk o

[COMMITTERS] pgsql: Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by

2008-03-12 Thread Tom Lane
Log Message: --- Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by postponing pg_listener modifications commanded by LISTEN and UNLISTEN until the end of the current transaction. This allows us to hold the ExclusiveLock on pg_listener until after commit, with no greater risk o

[COMMITTERS] pgsql: Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by

2008-03-12 Thread Tom Lane
Log Message: --- Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by postponing pg_listener modifications commanded by LISTEN and UNLISTEN until the end of the current transaction. This allows us to hold the ExclusiveLock on pg_listener until after commit, with no greater risk o

[COMMITTERS] pgsql: Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by

2008-03-12 Thread Tom Lane
Log Message: --- Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by postponing pg_listener modifications commanded by LISTEN and UNLISTEN until the end of the current transaction. This allows us to hold the ExclusiveLock on pg_listener until after commit, with no greater risk o

[COMMITTERS] pgsql: Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by

2008-03-12 Thread Tom Lane
Log Message: --- Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by postponing pg_listener modifications commanded by LISTEN and UNLISTEN until the end of the current transaction. This allows us to hold the ExclusiveLock on pg_listener until after commit, with no greater risk o

[COMMITTERS] pgsql: Add: > > * Consider a special data type for regular expressions

2008-03-12 Thread Bruce Momjian
Log Message: --- Add: > > * Consider a special data type for regular expressions > > http://archives.postgresql.org/pgsql-hackers/2007-08/msg01067.php Modified Files: -- pgsql/doc: TODO (r1.2325 -> r1.2326) (http://anoncvs.postgresql.org/cvsweb.cgi/pgs

[COMMITTERS] pgsql: Back out text search change to TODO.

2008-03-12 Thread Bruce Momjian
Log Message: --- Back out text search change to TODO. Modified Files: -- pgsql/doc: TODO (r1.2324 -> r1.2325) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2324&r2=1.2325) -- Sent via pgsql-committers mailing list (pgsql-committers@postgre

Re: [COMMITTERS] pgsql: Add to TODO: > > * Add array_accum() and array_to_set()

2008-03-12 Thread Bruce Momjian
David Fetter wrote: > On Wed, Mar 12, 2008 at 03:14:50PM +, Bruce Momjian wrote: > > Log Message: > > --- > > Add to TODO: > > > > > > > > * Add array_accum() and array_to_set() functions for arrays > > > > > > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00464.php > >

[COMMITTERS] pgsql: Update TODO: * Add array_accum() and array_to_set() functions

2008-03-12 Thread Bruce Momjian
Log Message: --- Update TODO: * Add array_accum() and array_to_set() functions for arrays The standards specify array_agg() and UNNEST. http://archives.postgresql.org/pgsql-hackers/2007-08/msg00464.php Modified Files: -- pgsql/doc: TODO (r1.2323 -> r1.2324)

[COMMITTERS] pgsql: Add URL for: * Consider a simplified API for full text searches

2008-03-12 Thread Bruce Momjian
Log Message: --- Add URL for: * Consider a simplified API for full text searches > http://archives.postgresql.org/pgsql-hackers/2007-08/msg01067.php Modified Files: -- pgsql/doc: TODO (r1.2322 -> r1.2323) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/

Re: [COMMITTERS] pgsql: Add to TODO: > > * Add array_accum() and array_to_set()

2008-03-12 Thread David Fetter
On Wed, Mar 12, 2008 at 03:14:50PM +, Bruce Momjian wrote: > Log Message: > --- > Add to TODO: > > > > > * Add array_accum() and array_to_set() functions for arrays > > > > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00464.php The draft SQL:2008 spec I got from http://

[COMMITTERS] pgsql: Add for Win32 TODO: > > o Convert MSVC build system to remove

2008-03-12 Thread Bruce Momjian
Log Message: --- Add for Win32 TODO: > > o Convert MSVC build system to remove most batch files > > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00961.php Modified Files: -- pgsql/doc: TODO (r1.2321 -> r1.2322) (http://anoncvs.po

[COMMITTERS] pgsql: Add URL for: * Add REINDEX CONCURRENTLY, like CREATE INDEX

2008-03-12 Thread Bruce Momjian
Log Message: --- Add URL for: * Add REINDEX CONCURRENTLY, like CREATE INDEX CONCURRENTLY > http://archives.postgresql.org/pgsql-performance/2007-08/msg00289.php Modified Files: -- pgsql/doc: TODO (r1.2320 -> r1.2321) (http://anoncvs.postgresql.org/cvswe

[COMMITTERS] autodoc - autodoc: Clean up formatting.

2008-03-12 Thread User Rbt
Log Message: --- Clean up formatting. Modified Files: -- autodoc: postgresql_autodoc.pl (r1.20 -> r1.21) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/autodoc/autodoc/postgresql_autodoc.pl.diff?r1=1.20&r2=1.21) -- Sent via pgsql-committers mailing list (pg

[COMMITTERS] autodoc - autodoc: Do not output all functions in the database if a

2008-03-12 Thread User Rbt
Log Message: --- Do not output all functions in the database if a specific table list was requested. Good chance it isn't functions the user is after. Modified Files: -- autodoc: postgresql_autodoc.pl (r1.19 -> r1.20) (http://cvs.pgfoundry.org/cgi-bin/cvsw

[COMMITTERS] autodoc - autodoc: Keep foreign key defaults (0) when referencing a

2008-03-12 Thread User Rbt
Log Message: --- Keep foreign key defaults (0) when referencing a table which does not exist in our output. Modified Files: -- autodoc: postgresql_autodoc.pl (r1.18 -> r1.19) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/autodoc/autodoc/postgresql_autodoc.p

[COMMITTERS] autodoc - autodoc: Leonardo Cezar patches: One of them to fix a odd

2008-03-12 Thread User Rbt
Log Message: --- Leonardo Cezar patches: One of them to fix a odd behavior when we had views in schema to schema to extract some reporter. Previously we got an error on trying to get statistcs from a view, since views hasn't stats. The other one to choose which table(s) we want to collect

[COMMITTERS] pgsql: Add for Win32 TODO: > o Diagnose problem where shared memory

2008-03-12 Thread Bruce Momjian
Log Message: --- Add for Win32 TODO: > o Diagnose problem where shared memory can sometimes not be > attached by postmaster children > > http://archives.postgresql.org/pgsql-general/2007-08/msg01377.php > Modified Files: -- pgsql/doc: TODO (r

[COMMITTERS] pgsql: Add to TODO: > > * Remove use of MAKE_PTR and MAKE_OFFSET

2008-03-12 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Remove use of MAKE_PTR and MAKE_OFFSET macros > > http://archives.postgresql.org/pgsql-general/2007-08/msg01510.php Modified Files: -- pgsql/doc: TODO (r1.2318 -> r1.2319) (http://anoncvs.postgresql.org/cvsweb.cgi/pg

[COMMITTERS] autodoc - autodoc: Tag for 1.31 release.

2008-03-12 Thread User Rbt
Log Message: --- Tag for 1.31 release. After additional testing to ensure Foriegn Keys work again this is what will go out. Modified Files: -- autodoc: ChangeLog (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/autodoc/autodoc/ChangeLog.diff?r1=

[COMMITTERS] autodoc - autodoc: New versions of DBD::Pg like to return an array

2008-03-12 Thread User Rbt
Log Message: --- New versions of DBD::Pg like to return an array reference instead of the special text string that PostgreSQL returns. This might take care of the issue, although only partially tested (FreeBSD ports doesn't have the newer version yet as it breaks a number of applications

[COMMITTERS] prefix - prefix: Implementation of some more operators for prefix_range:

2008-03-12 Thread User Dim
Log Message: --- Implementation of some more operators for prefix_range: =, <>, <<, <<=, >>, >>= Modified Files: -- prefix: prefix.c (r1.15 -> r1.16) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/prefix/prefix/prefix.c.diff?r1=1.15&r2=1.16) prefix.sq

[COMMITTERS] pgsql: Add to TODO: > > * Add array_accum() and array_to_set()

2008-03-12 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Add array_accum() and array_to_set() functions for arrays > > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00464.php Modified Files: -- pgsql/doc: TODO (r1.2317 -> r1.2318) (http://anoncvs.postgresql.org/c

[COMMITTERS] prefix - prefix: prefix_range datatype now has working in/out functions

2008-03-12 Thread User Dim
Log Message: --- prefix_range datatype now has working in/out functions and text casts Modified Files: -- prefix: prefix.c (r1.14 -> r1.15) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/prefix/prefix/prefix.c.diff?r1=1.14&r2=1.15) prefix.sql.in (r1.3