Re: DROP OWNED BY fails to clean out pg_init_privs grants - Mailing list pgsql-hackers

Then maybe we should put a query / function in the release notes to
clean up the existing mess.

Thinking of it we should do it anyway, as the patch only prevents new
messiness from happening and does not fix existing issues.

I could share a query to update the pg_init_privs with non-existent
role to replace it with the owner of the object if we figure out a
correct place to publish it.

---
Hannu




On Thu, Jun 20, 2024 at 5:35 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Hannu Krosing <hannuk@google.com> writes:
> > Is there anything that could be back-patched with reasonable effort ?
>
> Afraid not.  The whole thing is dependent on pg_shdepend entries
> that won't exist in older branches.
>
>                         regards, tom lane