model-writtenrun 7835 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Tom Lane proposed marking PUBLICATION TABLE archive entries with the publication owner so restores using --use-set-session-authorization execute ALTER PUBLICATION under that role #1.
- The patch links PublicationRelInfo to PublicationInfo, adds publication lookup by OID, and replaces per-table membership queries with one query of pg_publication_rel #1.
- Tom noted that adding tables requires ownership of both the publication and the tables, judged the publication owner the best role to use, and questioned the documentation's description of these permissions #1.
- The supplied thread ends with that proposal and contains no review replies; Tom subsequently committed the attached patch unchanged as 8e396a773b, with backpatching through PostgreSQL 10.