MIME-Version: 1.0
References: <CAERznn-QWVpAvqnyF=rZfiuxkeDG0tym_rY+RuEkSPWvzgi67Q@mail.gmail.com>
 <ca3fe7b5-2399-4537-bba4-cd000907bda7@postgrespro.ru> <CAERznn-SBBqQ3YcdZk9U4mqVQPsVgLisi=EdFzY5Fb7hOQ4g_Q@mail.gmail.com>
 <CAERznn-Hz_Y-V2gYP5UAcO+nU+e39o9WGDYTjpAqddyp8PMp4g@mail.gmail.com>
 <1484313.1764115685@sss.pgh.pa.us> <CAERznn-LSryEQuQAgMTZXYPi9NA-4M28VnOBVt0A4Uaxxwij+w@mail.gmail.com>
 <CAERznn_85XwgLbFVpeJenQ+Him81CJHBQ8fH+0iwrSYwhYQE2A@mail.gmail.com>
In-Reply-To: <CAERznn_85XwgLbFVpeJenQ+Him81CJHBQ8fH+0iwrSYwhYQE2A@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 25 Nov 2025 19:39:48 -0500
Message-ID: <CANzqJaC9soWEBNXnXpmstHpMYPEQk5HQ_n4YJTAqkVMdQbYkOg@mail.gmail.com>
Subject: Re: DROP ROLE blocked by pg_init_privs
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000de40f6064474a214"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaC9soWEBNXnXpmstHpMYPEQk5HQ_n4YJTAqkVMdQbYkOg%40mail.gmail.com>
Precedence: bulk

--000000000000de40f6064474a214
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Nov 25, 2025 at 7:36=E2=80=AFPM immerrr again <immerrr@gmail.com> w=
rote:

>
> > I have written a couple of queries to manually clean up the system
> tables pg_init_privs/pg_shdepends instead (see [1])
>
> Sorry, wrong link [1]. Should have been
>
> 1.
> https://www.postgresql.org/message-id/CAERznn-QWVpAvqnyF%3DrZfiuxkeDG0tym=
_rY%2BRuEkSPWvzgi67Q%40mail.gmail.com
>
>>
It would be interesting to see what's missing from the
information_schema.*_privileges views:
https://www.postgresql.org/docs/14/information-schema.html

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--000000000000de40f6064474a214
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Nov 25, 2025 at 7:36=E2=80=AFPM i=
mmerrr again &lt;<a href=3D"mailto:immerrr@gmail.com">immerrr@gmail.com</a>=
&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px =
solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">=
<br></div><div dir=3D"ltr">&gt; I have written a couple of queries to manua=
lly clean up the system tables pg_init_privs/pg_shdepends instead (see [1])=
</div><div dir=3D"ltr"><br></div><div dir=3D"ltr">Sorry, wrong link [1]. Sh=
ould have been<div><br></div><div>1.=C2=A0<a href=3D"https://www.postgresql=
.org/message-id/CAERznn-QWVpAvqnyF%3DrZfiuxkeDG0tym_rY%2BRuEkSPWvzgi67Q%40m=
ail.gmail.com" target=3D"_blank">https://www.postgresql.org/message-id/CAER=
znn-QWVpAvqnyF%3DrZfiuxkeDG0tym_rY%2BRuEkSPWvzgi67Q%40mail.gmail.com</a></d=
iv></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"></div></div>
</blockquote></div></div>
</blockquote></div><div><br clear=3D"all"></div><div>It would be interestin=
g to see what&#39;s missing from=C2=A0the information_schema.*_privileges v=
iews:</div><div><a href=3D"https://www.postgresql.org/docs/14/information-s=
chema.html">https://www.postgresql.org/docs/14/information-schema.html</a><=
/div><div><br></div><span class=3D"gmail_signature_prefix">-- </span><br><d=
iv dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Reda=
cted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br>=
<div><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>

--000000000000de40f6064474a214--