strk wrote: > 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 ...
Removed semicolon, thanks for the report -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers