projects / users / gsingh / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 99255d7) | patch
Fix transition tables for partition/inheritance.
authorAndrew Gierth <rhodiumtoad@postgresql.org>
Wed, 28 Jun 2017 17:55:03 +0000 (18:55 +0100)
committerAndrew Gierth <rhodiumtoad@postgresql.org>
Wed, 28 Jun 2017 17:55:03 +0000 (18:55 +0100)
commit501ed02cf6f4f60c3357775eb07578aebc912d3a
tree6811c9e9181dfff5ae384b9ec69994de2b777a2btree
parent99255d73c07c89b69be028a1a7b8027a78befed4commit | diff
Fix transition tables for partition/inheritance.

We disallow row-level triggers with transition tables on child tables.
Transition tables for triggers on the parent table contain only those
columns present in the parent.  (We can't mix tuple formats in a
single transition table.)

Patch by Thomas Munro

Discussion: https://postgr.es/m/CA%2BTgmoZzTBBAsEUh4MazAN7ga%3D8SsMC-Knp-6cetts9yNZUCcg%40mail.gmail.com
13 files changed:
doc/src/sgml/ref/create_trigger.sgml diff | blob | blame | history
src/backend/catalog/pg_inherits.c diff | blob | blame | history
src/backend/commands/copy.c diff | blob | blame | history
src/backend/commands/tablecmds.c diff | blob | blame | history
src/backend/commands/trigger.c diff | blob | blame | history
src/backend/executor/execMain.c diff | blob | blame | history
src/backend/executor/execReplication.c diff | blob | blame | history
src/backend/executor/nodeModifyTable.c diff | blob | blame | history
src/include/catalog/pg_inherits_fn.h diff | blob | blame | history
src/include/commands/trigger.h diff | blob | blame | history
src/include/nodes/execnodes.h diff | blob | blame | history
src/test/regress/expected/triggers.out diff | blob | blame | history
src/test/regress/sql/triggers.sql diff | blob | blame | history
Postgres clone for personal branches