Re: Problem with pg_try_advisory_lock and two connections (seemingly) getting the same lock

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Brett Hoerner <bretthoerner(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with pg_try_advisory_lock and two connections (seemingly) getting the same lock
Date: 2010-07-24 06:09:09
Message-ID: 4C4A8385.2010900@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 24/07/10 00:00, Merlin Moncure wrote:

> I generally agree with your statements, but there is one correction to
> make: advisory locks are not released at end of transaction.

Argh. Good point. Every other kind of lock is, but advisory locks are
only released when the connection is closed or the lock is explicitly
released.

Thanks for the correction.

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Allan Kamau 2010-07-24 06:56:26 Efficiently obtaining (any) one record per group.
Previous Message Scott Frankel 2010-07-23 23:32:17 Re: prepared statements