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

Started by Bruce Momjianabout 22 years ago1 messagescomitters

bruce@momjian.us

about 22 years ago

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)