Thread: pgsql-server: Change pg_dump to use ALTER OWNER commands instead of SET
pgsql-server: Change pg_dump to use ALTER OWNER commands instead of SET
From
momjian@svr1.postgresql.org (Bruce Momjian)
Date:
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)