model-writtenrun 9383 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Rushabh Lathia reported that dumping partitions with serial columns produced unrestorable output because inherited NOT NULL constraints were omitted, and supplied a small partition-specific fix in #1.
- Rushabh then demonstrated that inherited CHECK constraints were also missing, showing that partition constraints needed different treatment from traditional inheritance in #2.
- With minor releases imminent, Alvaro Herrera chose to revert the broken ATTACH PARTITION change in #3, and a1ec7402e9 implemented that rollback instead of applying the narrow fix immediately.
- Alvaro returned with a two-patch submission in #4 that restored the ATTACH PARTITION implementation credited to David Rowley, retained Rushabh's NOT NULL fix, added inherited CHECK handling, and tested serial columns, partition constraints, and traditional inheritance; he also raised an unresolved concern about sequence dependencies during partial restores.
- The revised series landed as 33a53130a8 with an additional guard preventing duplicate CHECK constraints during binary upgrade, plus naming, comment, and test cleanup; Alvaro explained that pg10 upgrade testing exposed the extra failure and confirmed deployment to three branches in #5.
- Tom Lane requested restored regression coverage for the upgrade failure in #6, and Alvaro promised to work on it and corrected his explanation of the missing coverage in #7, leaving that testing follow-up outstanding after the functional fix had landed.