pgsql: Fix bug in DROP OWNED BY.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix bug in DROP OWNED BY.
Date: 2022-09-28 15:01:52
Message-ID: E1odYZM-002PE8-4j@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix bug in DROP OWNED BY.

Commit 6566133c5f52771198aca07ed18f84519fac1be7 broke the case where
the role passed to DROP OWNED BY owns a database.

Report by Rushabh Lathia, who also provided a patch, but this patch
takes a slightly different approach to fixing the problem.

Discussion: http://postgr.es/m/CAGPqQf2vO+nbo=3yAdZ8v26Rbug7bY4YjPaPLZx=L1NZ9-CC3w@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/7188b9b0fdbb4dd99915626f171d820a56b98514

Modified Files
--------------
src/backend/catalog/pg_shdepend.c | 29 +++++++++++++++++++----------
src/bin/scripts/t/020_createdb.pl | 18 ++++++++++++++++++
2 files changed, 37 insertions(+), 10 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2022-09-28 15:19:36 pgsql: Change some errdetail() to errdetail_internal()
Previous Message Robert Haas 2022-09-28 13:55:46 pgsql: Revert 56-bit relfilenode change and follow-up commits.