model-writtenrun 371 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Richard Guo reported that installcheck against a long-lived cluster could fail when constraint OIDs crossed a power of ten, and proposed numeric OID sorting to replace textual sorting in #1.
- jian he suggested relation-name sorting with COLLATE "C" in #2, while Tom Lane pointed out that numeric OID sorting still fails at wraparound and recommended constraint-name sorting in #3.
- Richard adopted conname COLLATE "C" in #4, updated expected row ordering, and extended the fix to another query already sorting numerically by OID.
- Richard explained in #5 that relation-name sorting would not reliably order these results because the relation is constant in most queries and nonunique in others; Tom approved the revised patch in #6.
- Richard committed #4 unchanged as 262f2eea95, with backpatching through PostgreSQL 18, and confirmed completion in #7, leaving no outstanding patch work.