Floris Van Nee <florisvannee@Optiver.com> writes:
> I noticed I wasn't able to apply my usual pg_dump schema output without errors anymore after I dropped some roles.
Aftersome digging, I found it has to do with Postgres not correctly updating the pg_init_privs table upon dropping
roles.I can reproduce a similar scenario with the following steps (output from v13devel, but AFAIK all versions
affected,I ran into the issue on v11.2):
Hm, looks like we forgot to teach the dependency mechanism about
pg_init_privs privileges? (I didn't look yet.)
> Can I manually fix this by updating pg_init_privs catalog table?
Yeah, I think that would work. Obviously best to test in a throwaway
database ...
regards, tom lane