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; -- ok SELECT 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers