|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/mvcc.sgml,v 2.72 2009/06/17 21:58:49 tgl Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/mvcc.sgml,v 2.73 2010/02/24 14:10:24 alvherre Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="mvcc"> |
4 | 4 | <title>Concurrency Control</title> |
@@ -1080,7 +1080,7 @@ SELECT pg_advisory_lock(id) FROM foo WHERE id = 12345; -- ok |
1080 | 1080 | SELECT pg_advisory_lock(id) FROM foo WHERE id > 12345 LIMIT 100; -- danger! |
1081 | 1081 | SELECT pg_advisory_lock(q.id) FROM |
1082 | 1082 | ( |
1083 | | - SELECT id FROM foo WHERE id > 12345 LIMIT 100; |
| 1083 | + SELECT id FROM foo WHERE id > 12345 LIMIT 100 |
1084 | 1084 | ) q; -- ok |
1085 | 1085 | </screen> |
1086 | 1086 | In the above queries, the second form is dangerous because the |
|