Fix transition tables for wCTEs.
Andrew Gierth <rhodiumtoad@postgresql.org>
Fix transition tables for wCTEs. The original coding didn't handle this case properly; each separate DML substatement needs its own set of transitions. Patch by Thomas Munro Discussion: https://postgr.es/m/CAL9smLCDQ%3D2o024rBgtD4WihzX8B3C6u_oSQ2K3%2BR5grJrV0bg%40mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/copy.c | modified | +8 −10 |
| src/backend/commands/trigger.c | modified | +94 −129 |
| src/backend/executor/execReplication.c | modified | +6 −0 |
| src/backend/executor/nodeModifyTable.c | modified | +12 −4 |
| src/include/commands/trigger.h | modified | +13 −5 |
| src/test/regress/expected/triggers.out | modified | +20 −0 |
| src/test/regress/sql/triggers.sql | modified | +21 −0 |
Discussion
- PG10 transition tables, wCTEs and multiple operations on the same table 59 messages · 2017-06-02 → 2017-06-22