Change pg_dump to use ALTER OWNER commands instead of SET SESSION
Bruce Momjian <bruce@momjian.us>
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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/pg_dump.sgml | modified | +5 −5 |
| doc/src/sgml/ref/pg_restore.sgml | modified | +5 −5 |
| src/bin/pg_dump/pg_backup_archiver.c | modified | +144 −33 |
| src/bin/pg_dump/pg_backup.h | modified | +2 −1 |
| src/bin/pg_dump/pg_dump.c | modified | +6 −2 |
| src/bin/pg_dump/pg_restore.c | modified | +6 −2 |