]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Forbid FOR PORTION OF on views with INSTEAD OF triggers
authorPeter Eisentraut <peter@eisentraut.org>
Fri, 10 Jul 2026 08:08:21 +0000 (10:08 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Fri, 10 Jul 2026 08:09:49 +0000 (10:09 +0200)
commit5b5e99047ab0df2ef3d18de81176558e49015205
treefa94c9a96260872c10c05ef1be4628f18faefd2f
parent3334b0d9f25a897b8298c849d08909bdc532874a
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
src/backend/rewrite/rewriteHandler.c
src/test/regress/expected/updatable_views.out
src/test/regress/sql/updatable_views.sql