Re: DROP ROLE as SUPERUSER - Mailing list pgsql-general

Dominique Devienne <ddevienne@gmail.com> writes:
> On Fri, Feb 21, 2025 at 3:44 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> DROP OWNED also removes relevant permission entries (which can be
>> thought of as things owned by the role, if you hold your head at
>> the right angle).  See its man page.

> Except when it doesn't... I'm doing the DROP OWNED, and I'm getting
> several "WARNING:  no privileges could be revoked for ..." for SCHEMAs
> and ROUTINEs. (which BTW break my unit tests, which monitor outputs).

[ shrug... ]  With no details, it's impossible to comment on this.

            regards, tom lane