pgsql: Don't needlessly check the partition contraint twice

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Don't needlessly check the partition contraint twice
Date: 2018-06-11 21:12:53
Message-ID: E1fSU7R-0004YN-Uc@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Don't needlessly check the partition contraint twice

Starting with commit f0e44751d717, ExecConstraints was in charge of
running the partition constraint; commit 19c47e7c8202 modified that so
that caller could request to skip that checking depending on some
conditions, but that commit and 15ce775faa42 together introduced a small
bug there which caused ExecInsert to request skipping the constraint
check but have this not be honored -- in effect doing the check twice.
This could have been fixed in a very small patch, but on further
analysis of the involved function and its callsites, it turns out to be
simpler to give the responsibility of checking the partition constraint
fully to the caller, and return ExecConstraints to its original
(pre-partitioning) shape where it only checked tuple descriptor-related
constraints. Each caller must do partition constraint checking on its
own schedule, which is more convenient after commit 2f178441044 anyway.

Reported-by: David Rowley
Author: David Rowley, Álvaro Herrera
Reviewed-by: Amit Langote, Amit Khandekar, Simon Riggs
Discussion: https://postgr.es/m/CAKJS1f8w8+awsxgea8wt7_UX8qzOQ=Tm1LD+U1fHqBAkXxkW2w@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/5b0c7e2f757a2cbdd8e0c478de51bcb5606d3a93

Modified Files
--------------
src/backend/commands/copy.c | 33 +++++++++++++------------------
src/backend/executor/execMain.c | 31 ++++++++++++++++-------------
src/backend/executor/execPartition.c | 5 ++---
src/backend/executor/execReplication.c | 8 ++++++--
src/backend/executor/nodeModifyTable.c | 36 ++++++++++++++--------------------
src/include/executor/executor.h | 5 ++---
6 files changed, 56 insertions(+), 62 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2018-06-11 21:22:53 pgsql: Adjust error message
Previous Message Andrew Dunstan 2018-06-11 18:56:07 pgsql: Add a script to detect perl compile time errors and warnings