agora inbox for pgsql-committers@postgresql.org  
help / color / mirror / Atom feed
pgsql: Forbid FOR PORTION OF on views with INSTEAD OF triggers
2+ messages / 1 participants
[nested] [flat]

* pgsql: Forbid FOR PORTION OF on views with INSTEAD OF triggers
@ 2026-07-10 08:20 Peter Eisentraut <peter@eisentraut.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2026-07-10 08:20 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.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: https://www.postgresql.org/message-id/flat/CAJ7c6TME%2Bix6VRf-2TPnVTsj8qn_hy6sYAOmMhZEivwsu2wS6g%40m...

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* pgsql: Forbid FOR PORTION OF on views with INSTEAD OF triggers
@ 2026-07-10 08:20 Peter Eisentraut <peter@eisentraut.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2026-07-10 08:20 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.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: https://www.postgresql.org/message-id/flat/CAJ7c6TME%2Bix6VRf-2TPnVTsj8qn_hy6sYAOmMhZEivwsu2wS6g%40m...

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2026-07-10 08:20 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-07-10 08:20 pgsql: Forbid FOR PORTION OF on views with INSTEAD OF triggers Peter Eisentraut <peter@eisentraut.org>
2026-07-10 08:20 pgsql: Forbid FOR PORTION OF on views with INSTEAD OF triggers Peter Eisentraut <peter@eisentraut.org>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox