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 <t...@sss.pgh.pa.us> wrote: > > Hannu Krosing <han...@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