10000
We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
1 parent 912eb88 commit b5a6a52Copy full SHA for b5a6a52
doc/src/sgml/mvcc.sgml
@@ -1,4 +1,4 @@
1
-<!-- $PostgreSQL: pgsql/doc/src/sgml/mvcc.sgml,v 2.72 2009/06/17 21:58:49 tgl Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/mvcc.sgml,v 2.73 2010/02/24 14:10:24 alvherre Exp $ -->
2
3
<chapter id="mvcc">
4
<title>Concurrency Control</title>
@@ -1080,7 +1080,7 @@ SELECT pg_advisory_lock(id) FROM foo WHERE id = 12345; -- ok
1080
SELECT pg_advisory_lock(id) FROM foo WHERE id > 12345 LIMIT 100; -- danger!
1081
SELECT pg_advisory_lock(q.id) FROM
1082
(
1083
- SELECT id FROM foo WHERE id > 12345 LIMIT 100;
+ SELECT id FROM foo WHERE id > 12345 LIMIT 100
1084
) q; -- ok
1085
</screen>
1086
In the above queries, the second form is dangerous because the
0 commit comments