public inbox for [email protected]
help / color / mirror / Atom feedFrom: Peter Eisentraut <[email protected]>
To: [email protected]
Subject: pgsql: Prohibit locking clauses on GRAPH_TABLE
Date: Thu, 09 Jul 2026 08:16:34 +0000
Message-ID: <[email protected]> (raw)
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 <[email protected]>
Author: Ayush Tiwari <[email protected]>
Reviewed-by: Ashutosh Bapat <[email protected]>
Discussion: https://www.postgresql.org/message-id/flat/CAHg%2BQDcE9wp6nOEC3SCRQ90nrCO%3DQF%2BOZq1MG8Qc6hnusmogqw...
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/2e6578292a9184dcaae6c5abc235a26db9cb2973
Modified Files
--------------
src/backend/parser/analyze.c | 9 +++++++++
src/test/regress/expected/graph_table.out | 13 +++++++++++++
src/test/regress/sql/graph_table.sql | 4 ++++
3 files changed, 26 insertions(+)
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pgsql: Prohibit locking clauses on GRAPH_TABLE
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox