On Thu, Apr 3, 2008 at 11:45 AM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)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.