diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2022-04-14 21:52:20 +0200 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2022-04-14 21:52:20 +0200 |
| commit | 275e719d910459db747346a51d56185e2440763b (patch) | |
| tree | 172474bc502ef42e060dfe9be5e01ebf9f5b0fbb /doc/src | |
| parent | 5bb2b6abc8d6cf120a814317816e4384bcbb9c1e (diff) | |
Reword text on ROW SHARE lock as acquired by SELECT FOR <lock>
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 <lock strength>
is an option of regular SELECT.
Per suggestion from Joey Bodoia <jbodoia21@cmc.edu>
Reviewed-by: Joey Bodoia <jbodoia21@cmc.edu> (offlist)
Reviewed-by: Erikjan Rijkers <er@xs4all.nl>
Discussion: https://postgr.es/m/164908765512.682.17348032020747341013@wrigleys.postgresql.org
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/mvcc.sgml | 14 |
1 files 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 </para> <para> - The <command>SELECT FOR UPDATE</command> and - <command>SELECT FOR SHARE</command> commands acquire a - lock of this mode on the target table(s) (in addition to - <literal>ACCESS SHARE</literal> locks on any other tables - that are referenced but not selected - <option>FOR UPDATE/FOR SHARE</option>). + The <command>SELECT</command> command acquires a lock of this mode + on all tables on which one of the <option>FOR UPDATE</option>, + <option>FOR NO KEY UPDATE</option>, + <option>FOR SHARE</option>, or + <option>FOR KEY SHARE</option> options is specified + (in addition to <literal>ACCESS SHARE</literal> locks on any other + tables that are referenced without any explicit + <option>FOR ...</option> locking option). </para> </listitem> </varlistentry> |