model-writtenrun 1973 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Noah Misch opened the thread with a pg_upgrade schema-comparison failure caused by parallel restore changing OID assignment, and proposed logical sort keys for seven remaining object types plus an assertion against OID fallback in #1.
- Robert Haas supported logical ordering and broader backpatching, while requesting clearer explanations of object names and collation ordering in #2; Noah revised the comments in #3, and Robert refined and endorsed them in #4.
- Preparing backports exposed a domain-constraint crash and missing access-method metadata when dumping pre-v9.6 servers, so Noah's revised patch sorted domain constraints before table constraints, read older pg_am catalogs without dumping their access methods, and corrected the postfix-operator explanation in #5.
- Noah also proposed backporting the existing rule-ordering fix without another attachment in #5, and Robert accepted that prerequisite and completed his review of the revised development-branch patch in #6.
- Alexander Lakhin reported an actual buildfarm occurrence of the original constraint-order instability in #7, confirming that the anticipated failure was occurring in practice.
- The prerequisite rule-sorting backports landed as cc9a62c51a, 25388fb2cb, e99010cbd8, 5dd4957b28, and 9affed2634, implementing the unattached backport plan from #5.
- The main sorting fix landed unchanged from #5 as 0decd5e89d; Noah's announcement in #8 explained additional old-server compatibility adjustments needed only in the v13 and v14 backports.
- Alexander then demonstrated that default ACLs for different roles still reached the new assertion in #9, and Kirill Reshke supplied a role-name tiebreaker in #10.
- With a release wrap imminent, Noah proposed removing the assertion from stable branches while deferring the substantive fix in #11; Robert and Tom Lane agreed in #12 and #13, leading to 0d2734eac3 while retaining the assertion on master.
- Following Noah's request for regression objects in #11, Kirill added default privileges for two predefined roles and reported that the pg_upgrade test failed without the comparator fix and passed with it in #14.
- After the freeze, Noah committed Kirill's revised patch as b61a5c4bed, relocating the test statements and comparator branch and making cosmetic changes described in #17.
- The new tests exposed cross-version dump differences involving the MAINTAIN table privilege in #18, so Noah changed them to revoke USAGE on types in ad4412480d, explaining in #19 that type privileges were consistent across supported versions.
- Noah identified broader ACL-output issues and suggested comparing individual privilege bits in #19, but left that work for a separate thread and judged changing established MAINTAIN behavior too risky.
- Andres Freund proposed cross-version upgrade testing in CI in #20; Tom questioned its cost in #21, Noah explained the need for old source trees in #22, and Andres discussed optional cfbot coverage in #23.
- By the final exchanges, the submitted fixes and test repair had landed, while broader ACL improvements and CI expansion remained unimplemented; Noah and Tom described their existing manually run buildfarm-client upgrade tests in #24 and #25.