pgsql: Prohibit locking clauses on GRAPH_TABLE

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Prohibit locking clauses on GRAPH_TABLE
Date: 2026-07-09 08:16:34
Message-ID: E1whjvt-000Gwj-2b@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(at)gmail(dot)com>
Author: Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>
Reviewed-by: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Discussion: https://www.postgresql.org/message-id/flat/CAHg%2BQDcE9wp6nOEC3SCRQ90nrCO%3DQF%2BOZq1MG8Qc6hnusmogqw%40mail.gmail.com

Branch
------
REL_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/01c544e1afb99bc2a76803870010b7cd2907f3b5

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

Browse pgsql-committers by date

  From Date Subject
Next Message Thom Brown 2026-07-09 11:09:23 Re: pgsql: Refactor how some aux processes advertise their ProcNumber
Previous Message Peter Eisentraut 2026-07-09 08:00:59 pgsql: Fix outdated comment