pgsql: Fix reporting of constraint violations for table partitioning.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix reporting of constraint violations for table partitioning.
Date: 2017-01-04 19:36:46
Message-ID: E1cOrMc-0005Ue-QS@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix reporting of constraint violations for table partitioning.

After a tuple is routed to a partition, it has been converted from the
root table's row type to the partition's row type. ExecConstraints
needs to report the failure using the original tuple and the parent's
tuple descriptor rather than the ones for the selected partition.

Amit Langote

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/f1b4c771ea74f42447dccaed42ffcdcccf3aa694

Modified Files
--------------
src/backend/commands/copy.c | 11 ++----
src/backend/commands/tablecmds.c | 1 +
src/backend/executor/execMain.c | 67 +++++++++++++++++++++++++++++-----
src/backend/executor/nodeModifyTable.c | 15 +++-----
src/include/executor/executor.h | 4 +-
src/include/nodes/execnodes.h | 1 +
src/test/regress/expected/insert.out | 7 ++++
src/test/regress/sql/insert.sql | 6 +++
8 files changed, 86 insertions(+), 26 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message David Fetter 2017-01-04 19:54:07 Re: pgsql: Update copyright for 2017
Previous Message Tom Lane 2017-01-04 19:20:52 Re: pgsql: Update copyright for 2017