model-writtenrun 295 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Zsolt Parragi reported that partition-local deferrable unique constraints could break routed ON CONFLICT inserts in PostgreSQL 19 and master, depending on the data and index order, and supplied a narrow enforcement-timing check with regression tests #1.
- Mihail Nikalayeu identified related named-constraint failures involving deferrability and NULLS NOT DISTINCT, and Zsolt demonstrated that an unintended arbiter could silently turn an expected error into an update #4 #5.
- Michael Paquier requested broader named-constraint tests and suggested combining the related fixes; Mihail then supplied a shared exact-equivalence check for executor and planner use, including collation tests, which Zsolt endorsed #6 #7 #8.
- After a two-week lull, Nathan Bossart raised the approaching PostgreSQL 19beta4 freeze, Álvaro Herrera undertook to finish the fix, and Dmitry Dolgov questioned whether the helper's commentary implied broader interchangeability than its strict key matching allowed #9 #10 #11.
- Álvaro posted a lightly revised version preserving Mihail's implementation and tests, while identifying a longstanding nondeterministic-collation behavior that he considered a separate bug requiring a future backpatchable fix #12.
- Álvaro committed the final submission with light comment, error-message translation, and commit-message edits, backpatching through PostgreSQL 19, and announced that it was pushed #12 67fd7002b6 #13.
- After the commit, Álvaro clarified that the helper targets identical indexes created by REINDEX CONCURRENTLY; Dmitry narrowed his concern to an optional comment improvement, which Álvaro welcomed, leaving the regression fix landed and that wording follow-up open at the thread's end #14 #15 #16.