Horton

Forbid SJE with result relation

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: 8c441c082797f22ae96f50b641a8ef3f65c92b8d
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2024-01-09T08:01:22Z
Releases: 17.0 
Forbid SJE with result relation

The target relation for INSERT/UPDATE/DELETE/MERGE has a different behavior
than other relations in EvalPlanQual() and RETURNING clause.  This is why we
forbid target relation to be either source or target relation in SJE.
It's not clear if we could ever support this.

Reported-by: Alexander Lakhin
Discussion: https://postgr.es/m/b9e8f460-f9a6-0e9b-e8ba-60d59f0bc22c%40gmail.com

Files

PathChange+/−
src/backend/optimizer/plan/analyzejoins.c modified +11 −0
src/test/regress/expected/join.out modified +47 −29
src/test/regress/expected/updatable_views.out modified +10 −7
src/test/regress/sql/join.sql modified +16 −12

Discussion