On Thu, Apr 3, 2008 at 11:45 AM, Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
