pgsql: Forbid FOR PORTION OF on views with INSTEAD OF triggers - Mailing list pgsql-committers

From Peter Eisentraut
Subject pgsql: Forbid FOR PORTION OF on views with INSTEAD OF triggers
Date
Msg-id E1wi6Tb-000Q6X-1q@gemulon.postgresql.org
Whole thread
List pgsql-committers
Forbid FOR PORTION OF on views with INSTEAD OF triggers

Previously, an attempt to use these features together caused a crash.
Oversight of commit 8e72d914c528.

Tests are added also to show that the check for this should be in the
rewriter, not the parser, as an earlier patch version suggested.

Author: Aleksander Alekseev <aleksander@tigerdata.com>
Author: Paul A. Jungwirth <pj@illuminatedcomputing.com>
Discussion:
https://www.postgresql.org/message-id/flat/CAJ7c6TME%2Bix6VRf-2TPnVTsj8qn_hy6sYAOmMhZEivwsu2wS6g%40mail.gmail.com

Branch
------
REL_19_STABLE

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

Modified Files
--------------
src/backend/rewrite/rewriteHandler.c          |  8 +++
src/test/regress/expected/updatable_views.out | 71 ++++++++++++++++++++++++++
src/test/regress/sql/updatable_views.sql      | 73 +++++++++++++++++++++++++++
3 files changed, 152 insertions(+)


pgsql-committers by date:

Previous
From: Etsuro Fujita
Date:
Subject: pgsql: postgres_fdw: Remove SPI from postgresImportForeignStatistics.
Next
From: Fujii Masao
Date:
Subject: pgsql: postgres_fdw: Mark statistics import helpers as static