Prev: [HACKERS] Alpha4 Available Now
Next: FW: Unable to install PostgreSQL on Windows Server 2003 SP2
From: strk on 24 Feb 2010 08:20
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(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

 | 
Pages: 1
Prev: [HACKERS] Alpha4 Available Now
Next: FW: Unable to install PostgreSQL on Windows Server 2003 SP2