model-writtenrun 1159 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- After David G. Johnston requested a clean reproducer in #1, Ing. Marijo Kristo demonstrated that promoting a grantor to superuser prevented REVOKE from removing its earlier CONNECT grant, even with GRANTED BY, and consequently prevented dropping the grantee in #2; David confirmed the behavior in #3.
- Tom Lane explained in #4 that superuser grants and revokes act as the object owner and cautioned against changing that default; David clarified in #5 that the explicit GRANTED BY clause was also being ignored.
- Nathan Bossart proposed honoring an explicit grantor in #6, and Tom Lane supplied a refactor in #7 that centralized the handling in select_best_grantor() while identifying missing documentation and tests.
- Nathan and Tom favored checking inherited privileges over SET ROLE permission in #8 and #9, matching automatic grantor selection; Nathan subsequently sought additional standards and permissions feedback in #10.
- Nathan added documentation, regression tests, and a commit message in #11; Tom requested explicit inheritance wording in #12, Nathan incorporated it in #13, and Tom approved the final version in #14, while a broader documentation overhaul was deferred.
- Nathan committed #13 unchanged as dd1398f137, crediting Tom as co-author, and confirmed completion in #15; no patch remained pending.