pgsql: Fix things so that updatable views work with partitioned tables.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix things so that updatable views work with partitioned tables.
Date: 2017-01-24 20:55:15
Message-ID: E1cW87X-0006lu-KR@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix things so that updatable views work with partitioned tables.

Previously, ExecInitModifyTable was missing handling for WITH CHECK
OPTION, and view_query_is_auto_updatable was missing handling for
RELKIND_PARTITIONED_TABLE.

Amit Langote, reviewed by me.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/587cda35ca331128db6c61d406d312654572834a

Modified Files
--------------
src/backend/executor/nodeModifyTable.c | 40 +++++++++++++++++++++++++++
src/backend/rewrite/rewriteHandler.c | 3 +-
src/test/regress/expected/updatable_views.out | 24 ++++++++++++++++
src/test/regress/sql/updatable_views.sql | 19 +++++++++++++
4 files changed, 85 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2017-01-24 21:51:11 pgsql: Extend index AM API for parallel index scans.
Previous Message Robert Haas 2017-01-24 20:44:34 pgsql: Set ecxt_scantuple correctly for tuple routing.