]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Prohibit locking clauses on GRAPH_TABLE
authorPeter Eisentraut <peter@eisentraut.org>
Thu, 9 Jul 2026 08:10:07 +0000 (10:10 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Thu, 9 Jul 2026 08:10:32 +0000 (10:10 +0200)
commit01c544e1afb99bc2a76803870010b7cd2907f3b5
tree06f74a7ca54bdace50585138ce58ef06ac7564a9
parent0b1dbb74478051205c2befc90bac9d9f55524104
Prohibit locking clauses on GRAPH_TABLE

Specifying a locking clause (FOR UPDATE/SHARE) that names a
GRAPH_TABLE alias currently results in an unhelpful "unrecognized RTE
type: 8" error.  This commit explicitly prohibits specifying a locking
clause on a GRAPH_TABLE alias, raising a more user-friendly error
instead.

(Locking clause support for GRAPH_TABLE could be added as a separate
feature in the future.)

Author: SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>
Author: Ayush Tiwari <ayushtiwari.slg01@gmail.com>
Reviewed-by: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/CAHg%2BQDcE9wp6nOEC3SCRQ90nrCO%3DQF%2BOZq1MG8Qc6hnusmogqw%40mail.gmail.com
src/backend/parser/analyze.c
src/test/regress/expected/graph_table.out
src/test/regress/sql/graph_table.sql