[COMMITTERS] plpsm - plpgpsm: regress test

2007-01-16 Thread User Okbob
Log Message: --- regress test Modified Files: -- plpgpsm/src: Makefile (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/Makefile.diff?r1=1.2&r2=1.3) Added Files: --- plpgpsm/src/expected: plpgpsm.out (r1.1)

[COMMITTERS] plpsm - plpgpsm: added regress tests

2007-01-16 Thread User Okbob
Log Message: --- added regress tests Modified Files: -- plpgpsm/src: Makefile (r1.1.1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/Makefile.diff?r1=1.1.1.1&r2=1.2) ---(end of broadcast)--

[COMMITTERS] plpsm - plpgpsm: New Directory

2007-01-16 Thread User Okbob
Update of /cvsroot/plpsm/plpgpsm/src/sql In directory pgfoundry.org:/tmp/cvs-serv64690/sql Log Message: Directory /cvsroot/plpsm/plpgpsm/src/sql added to the repository ---(end of broadcast)--- TIP 6: explain analyze is your friend

[COMMITTERS] plpsm - plpgpsm: New Directory

2007-01-16 Thread User Okbob
Update of /cvsroot/plpsm/plpgpsm/src/expected In directory pgfoundry.org:/tmp/cvs-serv64690/expected Log Message: Directory /cvsroot/plpsm/plpgpsm/src/expected added to the repository ---(end of broadcast)--- TIP 9: In versions below 8.0, the plann

[COMMITTERS] pgsql: Mark TODO item "autovacuum on by default" as completed.

2007-01-16 Thread Bruce Momjian
Log Message: --- Mark TODO item "autovacuum on by default" as completed. Modified Files: -- pgsql/doc: TODO (r1.2041 -> r1.2042) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.2041&r2=1.2042) pgsql/doc/src/FAQ: TODO.html (r

[COMMITTERS] pgsql: Revise bgwriter fsync-request mechanism to improve robustness

2007-01-16 Thread Tom Lane
Log Message: --- Revise bgwriter fsync-request mechanism to improve robustness when a table is deleted. A backend about to unlink a file now sends a "revoke fsync" request to the bgwriter to make it clean out pending fsync requests. There is still a race condition where the bgwriter may t

[COMMITTERS] pgsql: vcbuild updates from Magnus: * After Markos patch, now builds

2007-01-16 Thread Neil Conway
Log Message: --- vcbuild updates from Magnus: * After Markos patch, now builds pgcrypto without zlib again * Updates README with xml info * xml requires xslt and iconv * disable unnecessary warning about __cdecl() * Add a buildenv.bat called from all other bat files to set up things like P

[COMMITTERS] pgsql: Implement width_bucket() for the float8 data type.

2007-01-16 Thread Neil Conway
Log Message: --- Implement width_bucket() for the float8 data type. The implementation is somewhat ugly logic-wise, but I don't see an easy way to make it more concise. When writing this, I noticed that my previous implementation of width_bucket() doesn't handle NaN correctly: postgr

[COMMITTERS] pgsql: Minor improvements to the TODO list.

2007-01-16 Thread Neil Conway
Log Message: --- Minor improvements to the TODO list. Add some URLs for some existing TODO items, and re-add a TODO item for an "estimated count" capability. Modified Files: -- pgsql/doc: TODO (r1.2040 -> r1.2041) (http://developer.postgresql.org/cvsweb.cgi

[COMMITTERS] plpsm - plpgpsm: consistent handling exit and continue handlers in

2007-01-16 Thread User Okbob
Log Message: --- consistent handling exit and continue handlers in atomic block. After catching exception I do rollback inner subtransaction -> needed for correct excecution of any handler, and then I do rollback uter atomic compound block, because I wont to correct execution all statemen

[COMMITTERS] pgsql: Fix incorrect permissions check in

2007-01-16 Thread Tom Lane
Log Message: --- Fix incorrect permissions check in information_schema.key_column_usage view: it was checking a pg_constraint OID instead of pg_class OID, resulting in "relation with OID n does not exist" failures for anyone who wasn't owner of the table being examined. Per bug #2848 f

[COMMITTERS] pgsql: Fix incorrect permissions check in

2007-01-16 Thread Tom Lane
Log Message: --- Fix incorrect permissions check in information_schema.key_column_usage view: it was checking a pg_constraint OID instead of pg_class OID, resulting in "relation with OID n does not exist" failures for anyone who wasn't owner of the table being examined. Per bug #2848 f

[COMMITTERS] pgsql: Enable autovacuum in the default configuration, per discussion.

2007-01-16 Thread Alvaro Herrera
Log Message: --- Enable autovacuum in the default configuration, per discussion. Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.101 -> r1.102) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml.diff?r1=1.101&r2=1.102)

[COMMITTERS] plpsm - plpgpsm: all kind of handlers for exceptions are supported

2007-01-16 Thread User Okbob
Log Message: --- all kind of handlers for exceptions are supported Modified Files: -- plpgpsm/src: gram.y (r1.28 -> r1.29) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/gram.y.diff?r1=1.28&r2=1.29) pl_exec.c (r1.23 -> r1.24)

[COMMITTERS] pgsql: Arrange for autovacuum to be killed when another operation wants

2007-01-16 Thread Alvaro Herrera
Log Message: --- Arrange for autovacuum to be killed when another operation wants to be alone accessing it, like DROP DATABASE. This allows the regression tests to pass with autovacuum enabled, which open the gates for finally enabling autovacuum by default. Modified Files: --