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

Commit3f8276a

Browse files
committed
doc: clarify when row-level locks are released
They are released just like table-level locks. Also clean up wording.Reported-by: me@sillymon.chDiscussion:https://postgr.es/m/158074944048.1095.4309647363871637715@wrigleys.postgresql.orgBackpatch-through: 9.5
1 parentd684700 commit3f8276a

File tree

1 file changed

+6
-3
lines changed

1 file changed

+6
-3
lines changed

‎doc/src/sgml/mvcc.sgml‎

Lines changed: 6 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1039,9 +1039,9 @@ ERROR: could not serialize access due to read/write dependencies among transact
10391039
</tip>
10401040

10411041
<para>
1042-
Once acquired, a lock is normally heldtillend of transaction. But if a
1042+
Once acquired, a lock is normally helduntil theend of the transaction. But if a
10431043
lock is acquired after establishing a savepoint, the lock is released
1044-
immediately if the savepoint is rolled back to. This is consistent with
1044+
immediately if the savepoint is rolled back. This is consistent with
10451045
the principle that <command>ROLLBACK</command> cancels all effects of the
10461046
commands since the savepoint. The same holds for locks acquired within a
10471047
<application>PL/pgSQL</application> exception block: an error escape from the block
@@ -1178,7 +1178,10 @@ ERROR: could not serialize access due to read/write dependencies among transact
11781178
conflicting locks on the same row, even in different subtransactions;
11791179
but other than that, two transactions can never hold conflicting locks
11801180
on the same row. Row-level locks do not affect data querying; they
1181-
block only <emphasis>writers and lockers</emphasis> to the same row.
1181+
block only <emphasis>writers and lockers</emphasis> to the same
1182+
row. Row-level locks are released at transaction end or during
1183+
savepoint rollback, just like table-level locks.
1184+
11821185
</para>
11831186

11841187
<variablelist>

0 commit comments

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