Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit275e719

Browse files
committed
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; butalso SELECT FOR UPDATE is not a command separate from SELECT, as theoriginal 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
1 parent5bb2b6a commit275e719

File tree

1 file changed

+8
-6
lines changed

1 file changed

+8
-6
lines changed

‎doc/src/sgml/mvcc.sgml

Lines changed: 8 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -932,12 +932,14 @@ ERROR: could not serialize access due to read/write dependencies among transact
932932
</para>
933933

934934
<para>
935-
The <command>SELECT FOR UPDATE</command> and
936-
<command>SELECT FOR SHARE</command> commands acquire a
937-
lock of this mode on the target table(s) (in addition to
938-
<literal>ACCESS SHARE</literal> locks on any other tables
939-
that are referenced but not selected
940-
<option>FOR UPDATE/FOR SHARE</option>).
935+
The <command>SELECT</command> command acquires a lock of this mode
936+
on all tables on which one of the <option>FOR UPDATE</option>,
937+
<option>FOR NO KEY UPDATE</option>,
938+
<option>FOR SHARE</option>, or
939+
<option>FOR KEY SHARE</option> options is specified
940+
(in addition to <literal>ACCESS SHARE</literal> locks on any other
941+
tables that are referenced without any explicit
942+
<option>FOR ...</option> locking option).
941943
</para>
942944
</listitem>
943945
</varlistentry>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp