Re: Transaction-scope advisory locks

Szymon Lipiński <mabewlun@gmail.com>

From: Szymon Guz <mabewlun@gmail.com>
To: Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>
Cc: pgsql-hackers@postgresql.org
Date: 2010-12-13T23:08:31Z
Lists: pgsql-hackers
On 13 December 2010 23:52, Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>wrote:

> Hi,
>
> I often find myself wanting advisory locks that are automatically released
> when the transaction ends, so here's a small patch trying to do just that.
>  I don't know much about the lock system so the patch is in the state "it
> looks like this would work".  Any comments on the technical details are
> welcome.  There's obviously a lot of documentation and READMEs to change
> too, but I thought I'd see what people think about the idea before going
> there.
>
> So, thoughts?
>
>
>
In my opinion changing current behavior is not a good idea. I know some
software that relies on current behavior and this would break it. Maybe add
that as an option, or add another type of advisory lock?

regards
Szymon