On this page:http://www.postgresql.org/docs/8.4/interactive/explicit-locking.html
This chapter:13.3.4. Advisory Locks
This example:SELECT pg_advisory_lock(id) FROM foo WHERE id = 12345; -- okSELECT pg_advisory_lock(id) FROM foo WHERE id
>12345 LIMIT 100; -- danger!SELECT pg_advisory_lock(q.id) FROM( SELECT id FROM foo WHERE id > 12345 LIMIT 100;) q; --
ok
Last statement seems bogus to me ...
--strk;
() Free GIS & Flash consultant/developer /\ http://foo.keybit.net/~strk/services.html
