model-writtenrun 8714 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Alvaro Herrera proposed enabling BEFORE ROW triggers on partitioned tables in #1, initially rejecting all partition-key changes through bytewise comparisons up the partition hierarchy while acknowledging an attribute-mapping bug.
- Peter Eisentraut supported the feature but emphasized fixing attribute ordering in #2; Ashutosh Bapat identified missing expression-key handling and proposed checking partition constraints in #3, explicitly recognizing the more permissive semantics in #4, which Peter supported in #5.
- Alvaro replaced the custom comparison machinery with ExecPartitionCheck() in #6, allowing changes that preserve partition membership and providing an error naming the trigger and original partition when they do not.
- Ashutosh reviewed the revised code in #7, requesting preservation of trigger-type validation, clearer diagnostics, and expression-key tests, then identified missing documentation updates in #8.
- Alvaro accepted those edits in #9 while retaining checks after each cloned trigger, declining to support multiple triggers that move a row out of its partition and back because of correctness concerns around cross-partition UPDATE.
- Alvaro committed #6 as 487e9861d0 with the defensive validation, diagnostic, test, and documentation changes, and confirmed the landing in #10.
- In January 2021, 李杰(慎追) questioned the UPDATE restriction because UPDATE already supports rerouting and asked about implementing broader support in #11 and #12; the feature remained committed, with these follow-up questions unanswered and no further patch attached.