Re: Transaction-scope advisory locks
Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>
From: Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>
To: Szymon Guz <mabewlun@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2010-12-13T23:14:22Z
Lists: pgsql-hackers
On 2010-12-14 1:08 AM +0200, Szymon Guz wrote: > On 13 December 2010 23:52, Marko Tiikkaja<marko.tiikkaja@cs.helsinki.fi>wrote: >> 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? Oh, I forgot to mention. The patch doesn't change any existing behaviour; the new behaviour can be invoked only by adding a new boolean argument: SELECT pg_advisory_lock(1, false); The lock space is the same though, but I don't feel strongly about it. Regards, Marko Tiikkaja