]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix mishandling of OLD/NEW references in subqueries in rule actions.
authorDean Rasheed <dean.a.rasheed@gmail.com>
Sat, 25 Feb 2023 14:43:57 +0000 (14:43 +0000)
committerDean Rasheed <dean.a.rasheed@gmail.com>
Sat, 25 Feb 2023 14:43:57 +0000 (14:43 +0000)
commit8e5b4e0013a8a24644243cdb9516ac52287a81c8
treed98dff47d7551d1c2e646d56726770d1f6a7ef91
parentcef1c9c0cf6e50ebe6d578d93a5d89e40774f764
Fix mishandling of OLD/NEW references in subqueries in rule actions.

If a rule action contains a subquery that refers to columns from OLD
or NEW, then those are really lateral references, and the planner will
complain if it sees such things in a subquery that isn't marked as
lateral. However, at rule-definition time, the user isn't required to
mark the subquery with LATERAL, and so it can fail when the rule is
used.

Fix this by marking such subqueries as lateral in the rewriter, at the
point where they're used.

Dean Rasheed and Tom Lane, per report from Alexander Lakhin.
Back-patch to all supported branches.

Discussion: https://postgr.es/m/5e09da43-aaba-7ea7-0a51-a2eb981b058b%40gmail.com
src/backend/rewrite/rewriteHandler.c
src/test/regress/expected/rules.out
src/test/regress/sql/rules.sql