pgsql: Fix transition tables for partition/inheritance.

From: Andrew Gierth <rhodiumtoad(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix transition tables for partition/inheritance.
Date: 2017-06-28 18:18:17
Message-ID: E1dQHXd-0007rb-0B@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/501ed02cf6f4f60c3357775eb07578aebc912d3a

Modified Files
--------------
doc/src/sgml/ref/create_trigger.sgml | 14 ++
src/backend/catalog/pg_inherits.c | 24 +++
src/backend/commands/copy.c | 70 ++++++-
src/backend/commands/tablecmds.c | 28 +++
src/backend/commands/trigger.c | 218 ++++++++++++++++----
src/backend/executor/execMain.c | 2 +-
src/backend/executor/execReplication.c | 6 +-
src/backend/executor/nodeModifyTable.c | 150 ++++++++++++--
src/include/catalog/pg_inherits_fn.h | 1 +
src/include/commands/trigger.h | 45 +++-
src/include/nodes/execnodes.h | 4 +
src/test/regress/expected/triggers.out | 326 ++++++++++++++++++++++++++---
src/test/regress/sql/triggers.sql | 365 ++++++++++++++++++++++++++++++---
13 files changed, 1143 insertions(+), 110 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2017-06-28 21:31:46 pgsql: Change pg_ctl to detect server-ready by watching status in postm
Previous Message Tom Lane 2017-06-28 16:30:38 pgsql: Second try at fixing tcp_keepalives_idle option on Solaris.