| From: | Jeff Davis <jdavis(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Fix lock release for role membership grants in DROP OWNED BY. |
| Date: | 2026-08-03 19:34:26 |
| Message-ID: | E1wqyQc-000000003MA-2EkW@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Fix lock release for role membership grants in DROP OWNED BY.
Commit 6566133c5f5 added a case for AuthMemRelationId in
AcquireDeletionLock(), but not ReleaseDeletionLock(). The fall-through
case would go to UnlockDatabaseObject(), which would raise a WARNING;
and the lock would be retained until the end of the transaction.
Add the missing branch.
Discussion: https://postgr.es/m/2487ddcd737d4fc8e408e87aa9ad4365eed3bbb3.camel@j-davis.com
Backpatch-through: 16
Branch
------
REL_17_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/25e54cec72ae30809a2fdf6fdf2b1f726bd9142a
Modified Files
--------------
src/backend/catalog/dependency.c | 3 +++
src/test/isolation/expected/drop-owned-grant.out | 8 +++++++
src/test/isolation/isolation_schedule | 1 +
src/test/isolation/specs/drop-owned-grant.spec | 30 ++++++++++++++++++++++++
4 files changed, 42 insertions(+)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2026-08-03 19:34:29 | pgsql: Fix lock release for role membership grants in DROP OWNED BY. |
| Previous Message | Jeff Davis | 2026-08-03 19:34:23 | pgsql: Fix lock release for role membership grants in DROP OWNED BY. |