Re: Clarification on DROP OWNED BY command in PG18

2025-09-16 Thread Nathan Bossart
Thanks for reporting. On Mon, Sep 15, 2025 at 10:43:06PM +0530, DIPESH DHAMELIYA wrote: > Starting from commit 98fc31d (PG18 only), there is a new behaviour for > DROP OWNED BY command where it deletes entries from pg_auth_members > (including entries with ADMIN option). This change can cause a us

Re: Clarification on DROP OWNED BY command in PG18

2025-09-16 Thread Tom Lane
Nathan Bossart writes: > On Mon, Sep 15, 2025 at 10:43:06PM +0530, DIPESH DHAMELIYA wrote: >> Starting from commit 98fc31d (PG18 only), there is a new behaviour for >> DROP OWNED BY command where it deletes entries from pg_auth_members >> (including entries with ADMIN option). This change can caus

Clarification on DROP OWNED BY command in PG18

2025-09-15 Thread DIPESH DHAMELIYA
Hello everyone,   Starting from commit 98fc31d (PG18 only), there is a new behaviour for DROP OWNED BY command where it deletes entries from pg_auth_members (including entries with ADMIN option). This change can cause a user/role to lose the ability to DROP the role for which DROP OWNED BY was