Re: [COMMITTERS] pgsql-server: Convert pg_stat_get_backend_idset to

2004-10-01 Thread Bruce Momjian
Great. That old code was a mess. --- Tom Lane wrote: > Log Message: > --- > Convert pg_stat_get_backend_idset to use the existing SRF support. > This seems the cleanest way of fixing its lack of a shutdown callback,

[COMMITTERS] pgsql-server: Update length from 75 to 79.

2004-10-01 Thread Bruce Momjian
Log Message: --- Update length from 75 to 79. Modified Files: -- pgsql-server/src/tools/pgindent: pgindent (r1.69 -> r1.70) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/tools/pgindent/pgindent.diff?r1=1.69&r2=1.70) -

[COMMITTERS] pginstaller - pginst: A late night visit from the message style police.

2004-10-01 Thread User Dpage
Log Message: --- A late night visit from the message style police. Modified Files: -- pginst/ca: pginstca.c (r1.49 -> r1.50) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/ca/pginstca.c.diff?r1=1.49&r2=1.50) sspi.c (r1.2 -> r1.3)

[COMMITTERS] pginstaller - pginst: Added more contrib modules - pgstattuple,

2004-10-01 Thread User Dpage
Log Message: --- Added more contrib modules - pgstattuple, rtree_gist, seg & 5 spi modules. Modified Files: -- pginst/ca: pginstca.c (r1.48 -> r1.49) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/ca/pginstca.c.diff?r1=1.48&r2=1.49) pgi

[COMMITTERS] pginstaller - web: Add question about Terminal Services installs.

2004-10-01 Thread User Mha
Log Message: --- Add question about Terminal Services installs. Restructure questions about filesystem permissions. Modified Files: -- web: FAQ_windows.html (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/web/FAQ_windows.html.diff?r1

[COMMITTERS] pginstaller - pginst: Add notice about permissions required on parent

2004-10-01 Thread User Mha
Log Message: --- Add notice about permissions required on parent directories of install. Modified Files: -- pginst/txt: welcome.rtf (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/txt/welcome.rtf.diff?r1=1.10&r2=1.11) -

[COMMITTERS] pgsql-server: Convert pg_stat_get_backend_idset to use the existing SRF

2004-10-01 Thread Tom Lane
Log Message: --- Convert pg_stat_get_backend_idset to use the existing SRF support. This seems the cleanest way of fixing its lack of a shutdown callback, which was preventing it from working correctly in a query that didn't run it to completion. Per bug report from Szima GÄbor. Tags: ---

[COMMITTERS] pginstaller - pginst: Bump version to beta3-dev1.

2004-10-01 Thread User Mha
Log Message: --- Bump version to beta3-dev1. Modified Files: -- pginst: Makefile (r1.19 -> r1.20) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/Makefile.diff?r1=1.19&r2=1.20) ---(end of broadcast)--

[COMMITTERS] pgsql-server: Convert pg_stat_get_backend_idset to use the existing SRF

2004-10-01 Thread Tom Lane
Log Message: --- Convert pg_stat_get_backend_idset to use the existing SRF support. This seems the cleanest way of fixing its lack of a shutdown callback, which was preventing it from working correctly in a query that didn't run it to completion. Per bug report from Szima GÄbor. Modified

[COMMITTERS] pginstaller - pginst: Explicitly look for "Everyone" and "Authenticated

2004-10-01 Thread User Mha
Log Message: --- Explicitly look for "Everyone" and "Authenticated Users" in "Administraotrs" and "Power Users". If found, give a more detailed error message about what has to be fixed. If not, do all the tests we already did as wel. Modified Files: -- pginst/ca:

[COMMITTERS] pgsql-server: fmgr_security_definer had better do a PG_TRY to ensure the

2004-10-01 Thread Tom Lane
Log Message: --- fmgr_security_definer had better do a PG_TRY to ensure the outer userid is restored on error exit. Modified Files: -- pgsql-server/src/backend/utils/fmgr: fmgr.c (r1.84 -> r1.85) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/

[COMMITTERS] pgsql-server: Adjust postmaster to recognize that a lockfile containing

2004-10-01 Thread Tom Lane
Log Message: --- Adjust postmaster to recognize that a lockfile containing its parent's PID must be stale. Tweak example startup scripts to not use pg_ctl but launch the postmaster directly, thereby ensuring that only the postmaster's direct parent shell will be a postgres-owned process.

[COMMITTERS] pginstaller - pginst: Don't crash when installing as a service but not

2004-10-01 Thread User Mha
Log Message: --- Don't crash when installing as a service but not initdb. Instead, skip starting the service, since it will not work until initdb is actually done. Modified Files: -- pginst/wxs: pginst.wxs (r1.65 -> r1.66) (http://cvs.pgfoundry.org/cgi-bin

[COMMITTERS] pgsql-server: Don't assume PQdb() will return a valid result from a

2004-10-01 Thread Tom Lane
Log Message: --- Don't assume PQdb() will return a valid result from a failed connection. Modified Files: -- pgsql-server/doc/src/sgml: libpq.sgml (r1.164 -> r1.165) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/libpq.sgml.diff?r1=1.

[COMMITTERS] pgsql-server: Don't assume PQdb() will return a valid result from a

2004-10-01 Thread Tom Lane
Log Message: --- Don't assume PQdb() will return a valid result from a failed connection. Modified Files: -- pgsql-server/src/bin/pg_dump: pg_backup_db.c (r1.58 -> r1.59) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/pg_dump/pg_backup_db.

[COMMITTERS] pgsql-server: Fallout from changing index locking rules: we can reduce

2004-10-01 Thread Tom Lane
Log Message: --- Fallout from changing index locking rules: we can reduce the strength of locking used by REINDEX. REINDEX needs only ShareLock on the parent table, same as CREATE INDEX, plus an exclusive lock on the specific index being processed. Modified Files: -- pgsql

[COMMITTERS] pgsql-server: Code review for NOWAIT patch: downgrade NOWAIT from fully

2004-10-01 Thread Tom Lane
Log Message: --- Code review for NOWAIT patch: downgrade NOWAIT from fully reserved keyword to unreserved keyword, use ereport not elog, assign a separate error code for 'could not obtain lock' so that applications will be able to detect that case cleanly. Modified Files: --

[COMMITTERS] pgsql-server: Remove DROPs from contrib object creation scripts, per

2004-10-01 Thread Tom Lane
Log Message: --- Remove DROPs from contrib object creation scripts, per Dave Page. Modified Files: -- pgsql-server/contrib/intagg: int_aggregate.sql.in (r1.5 -> r1.6) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/intagg/int_aggregate.sql.

[COMMITTERS] pginstaller - pginst: Add more contrib modules: misc_utils, noupdate,

2004-10-01 Thread User Dpage
Log Message: --- Add more contrib modules: misc_utils, noupdate, oid2name, pg_dumplog, pg_trgm, pgbench, pgcrypto. Modified Files: -- pginst/ca: pginstca.c (r1.46 -> r1.47) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/ca/pginstca.c.diff?

[COMMITTERS] pgbuildfarm - client-code: save logs from each stage in a log dir,

2004-10-01 Thread User Andrewd
Log Message: --- save logs from each stage in a log dir, overwritten each run unless we decide we don't need a run. Modified Files: -- client-code: run_build.pl (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbuildfarm/client-code/run_build.p

[COMMITTERS] pginstaller - pginst: Add more contrib modules: fulltextindex,

2004-10-01 Thread User Dpage
Log Message: --- Add more contrib modules: fulltextindex, fuzzystrmatch, int_aggregate, int_array, isbn_issn, lo & ltree. Modified Files: -- pginst/ca: pginstca.c (r1.45 -> r1.46) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/ca/pginstca.

[COMMITTERS] pgbuildfarm - client-code: support for success status date and changed

2004-10-01 Thread User Andrewd
Log Message: --- support for success status date and changed files lists Modified Files: -- client-code: run_build.pl (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbuildfarm/client-code/run_build.pl.diff?r1=1.2&r2=1.3)

[COMMITTERS] pginstaller - pginst: Install all contrib modules with the base server.

2004-10-01 Thread User Dpage
Log Message: --- Install all contrib modules with the base server. Allow the user to select which to install in template1 at initdb. Modified Files: -- pginst/ca: pginstca.c (r1.44 -> r1.45) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/c