Re: Typo in online docs

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Typo in online docs
Date: 2010-02-24 14:12:09
Message-ID: 20100224141209.GE3790@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gokulakannan Somasundaram 2010-02-24 14:41:00 Re: A thought on Index Organized Tables
Previous Message Dave Page 2010-02-24 13:50:54 Re: FW: Unable to install PostgreSQL on Windows Server 2003 SP2