Fix race condition between role grants and DROP ROLE

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v1, Patch count: 2, First patch: +63−6, All patches: +120−15

Topic

Bug Fixes

Created

2025-02-20 22:29:25

Last modified

2025-02-20 22:29:54 (1 day, 6 hours ago)

Latest email

2025-02-21 21:45:18 (7 hours, 41 minutes ago)

Status

2025-03: Needs review

Target version

stable

Authors

Tom Lane (tgl)

Reviewers

Committer

Links

Emails

Major Version Upgrade failure due to orphan roles entries in catalog: First at 2025-02-11 10:02:42 by Virender Singla <virender.cse at gmail.com>
Latest at 2025-02-21 21:45:18 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v1-0001-Avoid-race-condition-between-GRANT-role-and-DROP-.patch) at 2025-02-20 22:19:34 from Tom Lane <tgl at sss.pgh.pa.us>
Attachment (v1-0001-Avoid-race-condition-between-GRANT-role-and-DROP-.patch) at 2025-02-20 22:19:34 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
Attachment (add-missing-dependencies-for-pg_auth_members-wip.patch) at 2025-02-13 17:07:25 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)

History

When	Who	What
2025-02-20 22:29:54	Tom Lane (tgl)	Changed authors to Tom Lane (tgl)
2025-02-20 22:29:54	Tom Lane (tgl)	Changed targetversion to stable
2025-02-20 22:29:26	Tom Lane (tgl)	Attached mail thread CAM6Zo8woa62ZFHtMKox6a4jb8qQ=w87R2L0K8347iE-juQL2EA@mail.gmail.com
2025-02-20 22:29:25	Tom Lane (tgl)	Created patch record