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

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server: Change pg_dump to use ALTER OWNER commands instead of SET
Date: 2004-07-13 03:00:49
Message-ID: 20040713030049.122CBD1B342@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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 SET
behaviour

Christopher Kings-Lyne

Modified Files:
--------------
pgsql-server/doc/src/sgml/ref:
pg_dump.sgml (r1.72 -> r1.73)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/ref/pg_dump.sgml.diff?r1=1.72&r2=1.73)
pg_restore.sgml (r1.46 -> r1.47)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/ref/pg_restore.sgml.diff?r1=1.46&r2=1.47)
pgsql-server/src/bin/pg_dump:
pg_backup.h (r1.30 -> r1.31)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/pg_dump/pg_backup.h.diff?r1=1.30&r2=1.31)
pg_backup_archiver.c (r1.87 -> r1.88)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/pg_dump/pg_backup_archiver.c.diff?r1=1.87&r2=1.88)
pg_dump.c (r1.378 -> r1.379)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/pg_dump/pg_dump.c.diff?r1=1.378&r2=1.379)
pg_restore.c (r1.58 -> r1.59)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/pg_dump/pg_restore.c.diff?r1=1.58&r2=1.59)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2004-07-13 03:12:29 Re: Remove confusing commented-defaullts from postgresql.conf
Previous Message Tom Lane 2004-07-13 02:55:34 pgsql-server: Can't have blank lines in resultmap; some versions of expr