From: | Robert Haas <rhaas(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Fix failure to enforce partitioning contraint for internal parti |
Date: | 2017-01-19 17:39:47 |
Message-ID: | E1cUGgd-0005Kl-6Y@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Fix failure to enforce partitioning contraint for internal partitions.
When a tuple is inherited into a partitioning root, no partition
constraints need to be enforced; when it is inserted into a leaf, the
parent's partitioning quals needed to be enforced. The previous
coding got both of those cases right. When a tuple is inserted into
an intermediate level of the partitioning hierarchy (i.e. a table
which is both a partition itself and in turn partitioned), it must
enforce the partitioning qual inherited from its parent. That case
got overlooked; repair.
Amit Langote
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/39162b2030fb0a35a6bb28dc636b5a71b8df8d1c
Modified Files
--------------
src/backend/commands/copy.c | 1 -
src/backend/commands/tablecmds.c | 1 -
src/backend/executor/execMain.c | 42 ++++++++++++++++++++++++++++--------
src/include/executor/executor.h | 1 -
src/test/regress/expected/insert.out | 6 ++++++
src/test/regress/sql/insert.sql | 5 +++++
6 files changed, 44 insertions(+), 12 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2017-01-19 18:23:16 | pgsql: Fix RETURNING to work correctly with partition tuple routing. |
Previous Message | Stephen Frost | 2017-01-19 17:06:54 | pgsql: Dump sequence data based on the TableDataInfo flag |