Re: Orphaned users in PG16 and above can only be managed by Superusers

On 2025-Mar-24, Ashutosh Sharma wrote:

> Thank you, Robert and Tom, for sharing your valuable insights, and
> apologies for the slight delay in my response. From the discussion,
> what I understand is that we aim to extend the current DROP ROLE
> syntax to include the CASCADE/RESTRICT option, which has been
> introduced in the latest SQL standard, as mentioned by Tom. However,
> as Robert pointed out, implementing the CASCADE option for handling
> dependent objects that span multiple databases is not feasible at the
> moment. The RESTRICT option, as I understand it, is already the
> default behavior. Therefore, we will proceed with implementing the
> CASCADE/RESTRICT syntax specifically for handling dependent roles,
> rather than the dependent database objects like tables, views, etc.,
> which can span multiple databases.
>
> Please correct me if I’m mistaken or if there’s anything I’ve missed
> in my understanding. thanks.

Hello, is there a plan on this? I noticed a stale commitfest entry
that's still marked open,
https://commitfest.postgresql.org/patch/5608/
It's tagged as a bug fix, but I'm not clear that it is that.

--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
Syntax error: function hell() needs an argument.
Please choose what hell you want to involve.