model-writtenrun 3489 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Bartosz ChroĊ reported that pg_dumpall --roles-only --no-role-passwords unexpectedly omitted role comments, reproducing the behavior on PostgreSQL 14 and 16 across Windows and Ubuntu #1.
- Daniel Gustafsson traced the omission to switching the role catalog from pg_authid to pg_roles #2; Dominique Devienne demonstrated that comment lookup could still explicitly use pg_authid while selecting roles from pg_roles #3 #4.
- Alvaro Herrera located the original discussion, concluded that losing comments was accidental, and attached a patch fixing the catalog argument in all three role-comment queries #5.
- Daniel reported independently writing the same patch with an explanatory comment #6, and Alvaro asked him to commit it #7.
- The development fix landed as 7e65ad197f, preserving #5 with the additional comment; the other listed candidate, d82cb467bb, is its PostgreSQL 12 backport, whose older-server query adaptation contains a missing opening quote.
- Daniel closed the thread by confirming that the fix had been committed and backpatched to every supported version because the bug dated to 2017 #8; the thread contains no subsequent discussion of the backport's quoting defect.