[COMMITTERS] pgsql-server: Change pg_dump to use ALTER OWNER commands instead of SET

2004-07-12 Thread Bruce Momjian
Log Message: --- Change pg_dump to use ALTER OWNER commands instead of SET SESSION AUTHORIZATION commands by default. Move all GRANT and REVOKE commands to the end of the dump to avoid restore failures in several situations. Bring back --use-set-session-authorization option to get previous

Re: [COMMITTERS] pgsql-server: Rename join ordering named join_1.out

2004-07-12 Thread Bruce Momjian
Tom Lane wrote: > [EMAIL PROTECTED] (Bruce Momjian) writes: > > Rename join ordering named join_1.out > > I think you forgot to cvs add? Yep, added. I thought I had done it but obviously not. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED]

[COMMITTERS] pgsql-server: Can't have blank lines in resultmap; some versions of expr

2004-07-12 Thread Tom Lane
Log Message: --- Can't have blank lines in resultmap; some versions of expr complain. Modified Files: -- pgsql-server/src/test/regress: resultmap (r1.76 -> r1.77) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/test/regress/resultmap.diff?r1=1.

Re: [COMMITTERS] pgsql-server: Rename join ordering named join_1.out

2004-07-12 Thread Tom Lane
[EMAIL PROTECTED] (Bruce Momjian) writes: > Rename join ordering named join_1.out I think you forgot to cvs add? regards, tom lane ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan i

[COMMITTERS] pgsql-server: Add new join file.

2004-07-12 Thread Bruce Momjian
Log Message: --- Add new join file. Added Files: --- pgsql-server/src/test/regress/expected: join_1.out (r1.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/test/regress/expected/join_1.out?rev=1.1&content-type=text/x-cvsweb-markup)

[COMMITTERS] pgsql-server: Move tablespace name up on to the same line in psql \d.

2004-07-12 Thread Bruce Momjian
Log Message: --- Move tablespace name up on to the same line in psql \d. Modified Files: -- pgsql-server/src/bin/psql: describe.c (r1.100 -> r1.101) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/psql/describe.c.diff?r1=1.100&r2=1.101) --

[COMMITTERS] pgsql-server: Rename join ordering named join_1.out

2004-07-12 Thread Bruce Momjian
Log Message: --- Rename join ordering named join_1.out Modified Files: -- pgsql-server/src/test/regress: resultmap (r1.75 -> r1.76) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/test/regress/resultmap.diff?r1=1.75&r2=1.76) Removed Files: ---

Re: [COMMITTERS] pgsql-server: Add Win32-specific join ordering.

2004-07-12 Thread Bruce Momjian
Tom Lane wrote: > [EMAIL PROTECTED] (Bruce Momjian) writes: > > Add Win32-specific join ordering. > > This is exactly *not* the way we agreed to do it. It's better to treat > this as if it were a locale difference. > > Please revert the resultmap change and rename the expected file to > join_1.o

[COMMITTERS] pgsql-server: Cause libpq and ecpg libraries to be built as proper

2004-07-12 Thread Tom Lane
Log Message: --- Cause libpq and ecpg libraries to be built as proper shared libraries (.dylib format) on Mac OS X, while not messing up loadable modules for the backend (which are the same kind of animal as a shared library on every other platform, but not here). Also get the naming conve

[COMMITTERS] pgsql-server: Make installation instructions match reality.

2004-07-12 Thread Peter Eisentraut
Log Message: --- Make installation instructions match reality. Modified Files: -- pgsql-server/contrib/cube: README.cube (r1.5 -> r1.6) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/cube/README.cube.diff?r1=1.5&r2=1.6) pgsql-server/co

Re: [COMMITTERS] pgsql-server: Add Win32-specific join ordering.

2004-07-12 Thread Tom Lane
[EMAIL PROTECTED] (Bruce Momjian) writes: > Add Win32-specific join ordering. This is exactly *not* the way we agreed to do it. It's better to treat this as if it were a locale difference. Please revert the resultmap change and rename the expected file to join_1.out. reg

[COMMITTERS] pgsql-server: Add tablespace location display for psql \d.

2004-07-12 Thread Bruce Momjian
Log Message: --- Add tablespace location display for psql \d. Gavin Sherry Modified Files: -- pgsql-server/doc/src/sgml/ref: psql-ref.sgml (r1.116 -> r1.117) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/ref/psql-ref.sgml.diff?r1=1.

[COMMITTERS] pgsql-server: Add has_tablespace_privilege().

2004-07-12 Thread Bruce Momjian
Log Message: --- Add has_tablespace_privilege(). Christopher Kings-Lynne Modified Files: -- pgsql-server/doc/src/sgml: func.sgml (r1.213 -> r1.214) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/func.sgml.diff?r1=1.213&r2=1.214)

[COMMITTERS] pgsql-server: Add Win32-specific join ordering.

2004-07-12 Thread Bruce Momjian
Log Message: --- Add Win32-specific join ordering. Modified Files: -- pgsql-server/src/test/regress: resultmap (r1.74 -> r1.75) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/test/regress/resultmap.diff?r1=1.74&r2=1.75) Added Files: -

Re: [COMMITTERS] pgsql-server: Use strdup in pg_ctl for canonicalize_path

2004-07-12 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> You're not doing very well with this project :-(. pg_ctl is now > >> actively broken, because the PGDATA value passed down to the > >> bootstrap backend is the one in the environment variable. The > >> previous c

Re: [COMMITTERS] pgsql-server: Use strdup in pg_ctl for canonicalize_path on environment

2004-07-12 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> You're not doing very well with this project :-(. pg_ctl is now >> actively broken, because the PGDATA value passed down to the >> bootstrap backend is the one in the environment variable. The >> previous coding canonicalized that, th

[COMMITTERS] pgsql-server: Add blank line to new canonicalize_path file, which

2004-07-12 Thread Bruce Momjian
Log Message: --- Add blank line to new canonicalize_path file, which handles "a b\" properly. Modified Files: -- pgsql-server/src/port: path.c (r1.24 -> r1.25) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/port/path.c.diff?r1=1.24&r2=1.25) -

[COMMITTERS] pgsql-server: canonicalization adjustments.

2004-07-12 Thread Bruce Momjian
Log Message: --- canonicalization adjustments. Modified Files: -- pgsql-server/src/bin/pg_ctl: pg_ctl.c (r1.20 -> r1.21) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/pg_ctl/pg_ctl.c.diff?r1=1.20&r2=1.21) ---(end

Re: [COMMITTERS] pgsql-server: Use strdup in pg_ctl for canonicalize_path

2004-07-12 Thread Bruce Momjian
Tom Lane wrote: > [EMAIL PROTECTED] (Bruce Momjian) writes: > > Use strdup in pg_ctl for canonicalize_path on environment variable. > > Simplify postmaster call too. > > You're not doing very well with this project :-(. pg_ctl is now > actively broken, because the PGDATA value passed down to the

[COMMITTERS] pgsql-server: Put back canonicalization of PGDATA environment variable.

2004-07-12 Thread Bruce Momjian
Log Message: --- Put back canonicalization of PGDATA environment variable. Modified Files: -- pgsql-server/src/backend/postmaster: postmaster.c (r1.410 -> r1.411) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/postmaster/postmaster.c.d

Re: [COMMITTERS] pgsql-server: Use strdup in pg_ctl for canonicalize_path on environment

2004-07-12 Thread Tom Lane
[EMAIL PROTECTED] (Bruce Momjian) writes: > Use strdup in pg_ctl for canonicalize_path on environment variable. > Simplify postmaster call too. You're not doing very well with this project :-(. pg_ctl is now actively broken, because the PGDATA value passed down to the bootstrap backend is the on

[COMMITTERS] pgsql-server: Use strdup in pg_ctl for canonicalize_path on environment

2004-07-12 Thread Bruce Momjian
Log Message: --- Use strdup in pg_ctl for canonicalize_path on environment variable. Simplify postmaster call too. Modified Files: -- pgsql-server/src/backend/postmaster: postmaster.c (r1.409 -> r1.410) (http://developer.postgresql.org/cvsweb.cgi/pgsql-ser

[COMMITTERS] pgsql-server: This patch adds the following options to pg_dumpall, to be

2004-07-12 Thread Bruce Momjian
Log Message: --- This patch adds the following options to pg_dumpall, to be passed to pg_dump: -S, --superuser=NAME -O, --no-owner -X disable-dollar-quoting, --disable-dollar-quoting -X disable-triggers, --disable-triggers Christopher Kings-Lynne Modified Files: -- pgs

[COMMITTERS] pgsql-server: The attached patch, which incorporates the previous one

2004-07-12 Thread Bruce Momjian
Log Message: --- The attached patch, which incorporates the previous one sent and currently unapplied regarding spi_internal.c, makes some additional fixes relating to return types, and also contains the fix for preventing the use of insecure versions of Safe.pm. There is one remaing retu

[COMMITTERS] pgsql-server: > win32 doesn't support a static initializer for mutexes,

2004-07-12 Thread Bruce Momjian
Log Message: --- > win32 doesn't support a static initializer for mutexes, thus the first > user must initialize the lock. The problem are concurrent "first" users > - the pthread_mutex_t initialization must be synchronized. > The current implementation is broken, the attached patches fixes

[COMMITTERS] pgsql-server: Back out thread fix until I get clarification.

2004-07-12 Thread Bruce Momjian
Log Message: --- Back out thread fix until I get clarification. Modified Files: -- pgsql-server/src/interfaces/libpq: fe-connect.c (r1.276 -> r1.277) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/interfaces/libpq/fe-connect.c.diff?r1=1.276&r2

[COMMITTERS] pgsql-server: win32 doesn't support a static initializer for mutexes,

2004-07-12 Thread Bruce Momjian
Log Message: --- win32 doesn't support a static initializer for mutexes, thus the first user must initialize the lock. The problem are concurrent "first" users - the pthread_mutex_t initialization must be synchronized. The current implementation is broken, the attached patches fixes that: m