Re: advisory locks (was: 8.2 beta blockers)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: advisory locks (was: 8.2 beta blockers)
Date: 2006-09-19 16:15:38
Message-ID: 6910.1158682538@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Merlin Moncure" <mmoncure(at)gmail(dot)com> writes:
> two questions: do we need both a shared and unshared variant of
> advisory_unlock (im guessing no)?

Yes, because it's possible to hold both shared and exclusive lock
concurrently, so you have to say which you're releasing.

> also, are we exposing the mode in
> the int4/int4 signature or are all advisory locks assumed to be
> exclusive (if yes, which int4 is the lockmode).

Huh?

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris Browne 2006-09-19 16:15:40 Re: vista
Previous Message Tom Lane 2006-09-19 16:13:04 Re: [HACKERS] Incrementally Updated Backup