public inbox for [email protected]help / color / mirror / Atom feed
pgsql: Prohibit locking clauses on GRAPH_TABLE 2+ messages / 1 participants [nested] [flat]
* pgsql: Prohibit locking clauses on GRAPH_TABLE @ 2026-07-09 08:16 Peter Eisentraut <[email protected]> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2026-07-09 08:16 UTC (permalink / raw) To: [email protected] 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(+) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Prohibit locking clauses on GRAPH_TABLE @ 2026-07-09 08:16 Peter Eisentraut <[email protected]> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2026-07-09 08:16 UTC (permalink / raw) To: [email protected] 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 ------ 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(+) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-07-09 08:16 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-07-09 08:16 pgsql: Prohibit locking clauses on GRAPH_TABLE Peter Eisentraut <[email protected]> 2026-07-09 08:16 pgsql: Prohibit locking clauses on GRAPH_TABLE Peter Eisentraut <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox