Re: dump cannot be restored if schema permissions revoked

2021-05-14 Thread Noah Misch
On Wed, Apr 07, 2021 at 10:13:30AM -0700, Richard Yen wrote: > I noticed that in some situations involving the use of REVOKE ON SCHEMA, > pg_dump > can produce a dump that cannot be restored. This prevents successful > pg_restore (and by corollary, pg_upgrade). > > An example shell script to recr

dump cannot be restored if schema permissions revoked

2021-04-07 Thread Richard Yen
Hello hackers, I noticed that in some situations involving the use of REVOKE ON SCHEMA, pg_dump can produce a dump that cannot be restored. This prevents successful pg_restore (and by corollary, pg_upgrade). An example shell script to recreate this problem is attached. The error output appears