Re: choosing the right locking mode - Mailing list pgsql-general

On Thu, Apr 3, 2008 at 11:45 AM, Craig Ringer
<craig@postnewspapers.com.au> wrote:
> rihad wrote:
>  > Given this type query:
>  >
>  >         UPDATE bw_pool
>  >         SET user_id=?
>  >         WHERE bw_id=
>  >                 (SELECT MIN(bw_id) FROM bw_pool WHERE user_id IS NULL)
>  >         RETURNING bw_id
>
>  Can you use a SERIALIZABLE transaction and avoid the explicit lock?

I'm pretty sure serializable won't fix this.