Fix race condition between role grants and DROP ROLE

Title

CI (CFBot)

Needs rebase! Needs rebase since 1 month.
Additional links previous successfully applied patch (outdated):

Summary

Stats (from CFBot)

Unknown

Topic

Bug Fixes

Created

2025-02-20 22:29:25

Last modified

2025-02-22 23:17:09 (1 month ago)

Latest email

2025-03-04 15:17:07 (3 weeks ago)

Status

2025-03: Committed

Target version

stable

Authors

Tom Lane (tgl)

Reviewers

Committer

Tom Lane (tgl)

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-03-04 15:17:07 by Robert Haas <robertmhaas at gmail.com>
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-22 23:17:09	Tom Lane (tgl)	Closed in commitfest 2025-03 with status: Committed
2025-02-22 23:17:09	Tom Lane (tgl)	Changed committer to tgl
2025-02-22 23:06:28	CFbot	Patch needs rebase
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