Re: Advisory locks seem rather broken - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Advisory locks seem rather broken
Date
Msg-id CAHyXU0ybpOfw8HCvHJtfjMrwYS3ZAk0PCvxUh9Zu_upA-AV0_Q@mail.gmail.com
Whole thread Raw
In response to Re: Advisory locks seem rather broken  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Advisory locks seem rather broken
List pgsql-hackers
On Thu, May 3, 2012 at 11:04 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I'm inclined to think that a saner implementation would involve
> splitting the userlock lockmethod into two, one transactional and one
> not.  That gets rid of the when-to-release kluges, but instead we have
> to think of a way for two different lockmethods to share the same
> lock keyspace.  If we don't split it then we definitely need to figure
> out someplace else to keep the transactionality flag.

hm, would that be exposed through the pg_locks view?  some users might
be running queries like "select * from pg_locks where
locktype='advisory' and ..."

it's a minor point, but ideally if they share the same lockspace the
same locktype would be reported in the view.

merlin


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: remove dead ports?
Next
From: Simon Riggs
Date:
Subject: Re: Advisory locks seem rather broken