From 275e719d910459db747346a51d56185e2440763b Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Thu, 14 Apr 2022 21:52:20 +0200 Subject: [PATCH] Reword text on ROW SHARE lock as acquired by SELECT FOR It was missing lock levels FOR KEY SHARE and FOR NO KEY EXCLUSIVE; but also SELECT FOR UPDATE is not a command separate from SELECT, as the original text implied. It is clearer to state that FOR is an option of regular SELECT. Per suggestion from Joey Bodoia Reviewed-by: Joey Bodoia (offlist) Reviewed-by: Erikjan Rijkers Discussion: https://postgr.es/m/164908765512.682.17348032020747341013@wrigleys.postgresql.org --- doc/src/sgml/mvcc.sgml | 14 ++++++++------ 1 file changed, 8 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml index 905460723c5..341fea524a1 100644 --- a/doc/src/sgml/mvcc.sgml +++ b/doc/src/sgml/mvcc.sgml @@ -932,12 +932,14 @@ ERROR: could not serialize access due to read/write dependencies among transact - The SELECT FOR UPDATE and - SELECT FOR SHARE commands acquire a - lock of this mode on the target table(s) (in addition to - ACCESS SHARE locks on any other tables - that are referenced but not selected - ). + The SELECT command acquires a lock of this mode + on all tables on which one of the , + , + , or + options is specified + (in addition to ACCESS SHARE locks on any other + tables that are referenced without any explicit + locking option). -- 2.39.5