Re: [COMMITTERS] pgsql-server: OK, another try at Darwin threads.

2004-07-10 Thread Bruce Momjian
Tom Lane wrote: > [EMAIL PROTECTED] (Bruce Momjian) writes: > > Log Message: > > --- > > OK, another try at Darwin threads. > > > Tags: > > > > REL7_4_STABLE > > Seems to me that unproven fixes do not belong in stable branches. The fix was tested by several people on several version

[COMMITTERS] pgsql-server: Clarify schema meanings in pg_dump manual page by

2004-07-10 Thread Bruce Momjian
Log Message: --- Clarify schema meanings in pg_dump manual page by referring to object definitions more frequently. Modified Files: -- pgsql-server/doc/src/sgml/ref: pg_dump.sgml (r1.71 -> r1.72) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/

Re: [COMMITTERS] pgsql-server: OK, another try at Darwin threads.

2004-07-10 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> [EMAIL PROTECTED] (Bruce Momjian) writes: >>> OK, another try at Darwin threads. >> >> Seems to me that unproven fixes do not belong in stable branches. > The fix was tested by several people on several versions of OSX, and it > is on

Re: [COMMITTERS] pgsql-server: OK, another try at Darwin threads.

2004-07-10 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> [EMAIL PROTECTED] (Bruce Momjian) writes: > >>> OK, another try at Darwin threads. > >> > >> Seems to me that unproven fixes do not belong in stable branches. > > > The fix was tested by several people on several

[COMMITTERS] pgsql-server: Test HAVING condition before computing targetlist of an

2004-07-10 Thread Tom Lane
Log Message: --- Test HAVING condition before computing targetlist of an Aggregate node. This is required by SQL spec to avoid failures in cases like SELECT sum(win)/sum(lose) FROM ... GROUP BY ... HAVING sum(lose) > 0; AFAICT we have gotten this wrong since day one. Kudos to Holger Jako

[COMMITTERS] pgsql-server: Test HAVING condition before computing targetlist of an

2004-07-10 Thread Tom Lane
Log Message: --- Test HAVING condition before computing targetlist of an Aggregate node. This is required by SQL spec to avoid failures in cases like SELECT sum(win)/sum(lose) FROM ... GROUP BY ... HAVING sum(lose) > 0; AFAICT we have gotten this wrong since day one. Kudos to Holger Jako

[COMMITTERS] pgsql-server: Fix BSD-only coding in port.c (passing a local variable to

2004-07-10 Thread Tom Lane
Log Message: --- Fix BSD-only coding in port.c (passing a local variable to putenv). Also a quick but half-baked attempt to make trim_trailing_separator do the right thing with path consisting only of '/' --- still needs work for Windows I think. Modified Files: -- pgsql-se

[COMMITTERS] pgsql-server: Check more test points (in fact, every week in 1970..2004)

2004-07-10 Thread Tom Lane
Log Message: --- Check more test points (in fact, every week in 1970..2004) to get a more accurate matching of our time zone to the system's zone. This method is able to distinguish Antarctica/Casey from Australia/Perth, as in Chris K-L's recent example; and it is not materially slower tha

[COMMITTERS] pgsql-server: Defend against overrun of ExtraOptions array --- strictly

2004-07-10 Thread Tom Lane
Log Message: --- Defend against overrun of ExtraOptions array --- strictly paranoia, since the person or script starting the postmaster has to be trusted anyway. Modified Files: -- pgsql-server/src/backend/postmaster: postmaster.c (r1.405 -> r1.406) (http:/

[COMMITTERS] pgsql-server: Add: > * Add include functionality to postgresql.conf >

2004-07-10 Thread Bruce Momjian
Log Message: --- Add: > * Add include functionality to postgresql.conf > Modified Files: -- pgsql-server/doc: TODO (r1.1289 -> r1.1290) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/TODO.diff?r1=1.1289&r2=1.1290) ---

[COMMITTERS] pgsql-server: Allow configuration files to be placed outside the data

2004-07-10 Thread Bruce Momjian
Log Message: --- Allow configuration files to be placed outside the data directory. Add new postgresql.conf variables to point to data, pg_hba.conf, and pg_ident.conf files. Needs more documentation. Modified Files: -- pgsql-server/doc/src/sgml: runtime.sgml (r1.2

[COMMITTERS] pgsql-server: Add: < > * Use a phantom command counter for nested

2004-07-10 Thread Bruce Momjian
Log Message: --- Add: < > * Use a phantom command counter for nested subtransactions to reduce > tuple overhead Modified Files: -- pgsql-server/doc: TODO (r1.1290 -> r1.1291) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/TODO.diff?r1=1.12

[COMMITTERS] pgsql-server: Add: > * Add an option to sync() before fsync()'ing

2004-07-10 Thread Bruce Momjian
Log Message: --- Add: > * Add an option to sync() before fsync()'ing checkpoint files Modified Files: -- pgsql-server/doc: TODO (r1.1291 -> r1.1292) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/TODO.diff?r1=1.1291&r2=1.1292) -

[COMMITTERS] pgsql-server: Open files in binary mode on Win32 so control-z isn't seen

2004-07-10 Thread Bruce Momjian
Log Message: --- Open files in binary mode on Win32 so control-z isn't seen as EOF. Modified Files: -- pgsql-server/src/bin/psql: command.c (r1.117 -> r1.118) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/psql/command.c.diff?r1=1.117&r2=1

Re: [COMMITTERS] pgsql-server: Check more test points (in fact, every

2004-07-10 Thread Christopher Kings-Lynne
Cool, that fixes the detection for me. Chris Tom Lane wrote: Log Message: --- Check more test points (in fact, every week in 1970..2004) to get a more accurate matching of our time zone to the system's zone. This method is able to distinguish Antarctica/Casey from Australia/Perth, as in Ch

[COMMITTERS] pgsql-server: Add: > * Allow changing of already-created database and

2004-07-10 Thread Bruce Momjian
Log Message: --- Add: > * Allow changing of already-created database and schema tablespaces Modified Files: -- pgsql-server/doc: TODO (r1.1292 -> r1.1293) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/TODO.diff?r1=1.1292&r2=1.1293)

[COMMITTERS] pgsql-server: Fix trim_trailing_separator() to not trim c:\ nor

2004-07-10 Thread Bruce Momjian
Log Message: --- Fix trim_trailing_separator() to not trim c:\ nor \\network\ on Win32. Modified Files: -- pgsql-server/src/port: path.c (r1.21 -> r1.22) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/port/path.c.diff?r1=1.21&r2=1.22) ---

[COMMITTERS] plperlng - plperlng: fix for Safe version fix for return types remove

2004-07-10 Thread User Andrewd
Log Message: --- fix for Safe version fix for return types remove functions from ppport.h Modified Files: -- plperlng: plperl.c (r1.12 -> r1.13) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plperlng/plperlng/plperl.c.diff?r1=1.12&r2=1.13) ppport.h

[COMMITTERS] pgsql-server: Add: > * Allow moving system tables to other tablespaces,

2004-07-10 Thread Bruce Momjian
Log Message: --- Add: > * Allow moving system tables to other tablespaces, where possible Modified Files: -- pgsql-server/doc: TODO (r1.1293 -> r1.1294) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/TODO.diff?r1=1.1293&r2=1.1294) --

[COMMITTERS] pgsql-server: Cause the format of BC timestamptz output to be 'datetime

2004-07-10 Thread Tom Lane
Log Message: --- Cause the format of BC timestamptz output to be 'datetime zone BC' rather than 'datetime BC zone', because the former is accepted by the timestamptz input converter while the latter may not be depending on spacing. This is not a loss of compatibility w.r.t. 7.4 and before,