pgsql: Don't needlessly check the partition contraint twice
От | Alvaro Herrera |
---|---|
Тема | pgsql: Don't needlessly check the partition contraint twice |
Дата | |
Msg-id | E1fSU7R-0004YN-Uc@gemulon.postgresql.org обсуждение исходный текст |
Список | 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(-)
В списке pgsql-committers по дате отправления: