Fix RETURNING to work correctly with partition tuple routing.
Robert Haas <rhaas@postgresql.org>
Fix RETURNING to work correctly with partition tuple routing. In ExecInsert(), do not switch back to the root partitioned table ResultRelInfo until after we finish ExecProcessReturning(), so that RETURNING projection is done using the partition's descriptor. For the projection to work correctly, we must initialize the same for each leaf partition during ModifyTableState initialization. Amit Langote
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/catalog/partition.c | modified | +5 −3 |
| src/backend/commands/tablecmds.c | modified | +1 −0 |
| src/backend/executor/execMain.c | modified | +2 −2 |
| src/backend/executor/nodeModifyTable.c | modified | +34 −9 |
| src/include/catalog/partition.h | modified | +2 −1 |
| src/test/regress/expected/insert.out | modified | +23 −1 |
| src/test/regress/sql/insert.sql | modified | +15 −1 |