model-writtenrun 5863 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Andrew Bille reported that pg_upgrade failed when restoring role memberships granted by another role, because a recent permissions change rejected the recorded grantor #1.
- Tom Lane reproduced the failure without pg_upgrade and explained that previously permitted role grants should remain possible #2.
- Daniel Gustafsson questioned whether the restriction followed the SQL specification but proposed reverting it to preserve existing behavior, asking how broadly the revert should extend #4.
- Tom Lane argued that compatibility took precedence, identified a testing gap and additional role-grant permission problems, and recommended achieving consistency by adding capabilities; Daniel agreed to prepare a revert and leave a proper fix for separate work #5 #6.
- Daniel posted the revert after running it through CI, retaining the regression tests to document current behavior and planning to push the next morning #7.
- The posted patch landed unchanged as e68570e388 and was backpatched to PostgreSQL 14; the broader permission issues discussed in #5 remained outside this fix.