pgsql: Forbid FOR PORTION OF on views with INSTEAD OF triggers

Started by Peter Eisentraut5 months ago1 messagescommitters
Jump to latest
#1Peter Eisentraut
peter@eisentraut.org

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: /messages/by-id/CAJ7c6TME+ix6VRf-2TPnVTsj8qn_hy6sYAOmMhZEivwsu2wS6g@mail.gmail.com

Branch
------
master

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

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(+)