pgsql: Reject child partition FDWs in FOR PORTION OF

Поиск
Список
Период
Сортировка
Искать

pgsql: Reject child partition FDWs in FOR PORTION OF

От:
Peter Eisentraut <peter@eisentraut.org>
Дата:
Reject child partition FDWs in FOR PORTION OF

We should defer validating FDW usage until after analysis.  We have to
guard against not just the topmost table, but also individual child
partitions.  Added the check to CheckValidResultRel, because it is
called after looking up child partitions (accounting for pruning), but
before the FDW can run a DirectModify update, which would bypass
per-tuple executor work.

Author: jian he 
Reported-by: Tom Lane 
Reviewed-by: Paul A. Jungwirth 
Discussion: https://www.postgresql.org/message-id/flat/CA%2BrenyUte0_UJsJiDJQi82oaBsMJn%3Dcct0Wn%3DvOqXtuDn%3DYYJA%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/a40fdf658862b3221a35268f8c74abfd46b9e93c

Modified Files
--------------
contrib/postgres_fdw/expected/postgres_fdw.out | 42 ++++++++++++++++++++++++--
contrib/postgres_fdw/sql/postgres_fdw.sql      | 30 ++++++++++++++++--
src/backend/commands/copyfrom.c                |  2 +-
src/backend/executor/execMain.c                | 11 ++++++-
src/backend/executor/execPartition.c           |  4 +--
src/backend/executor/nodeModifyTable.c         |  2 +-
src/backend/parser/analyze.c                   |  6 ----
src/include/executor/executor.h                |  2 +-
8 files changed, 81 insertions(+), 18 deletions(-)

FAQ