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