Re: Serialization, Locking...implement processing Queue with a table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "D(dot) Dante Lorenso" <dante(at)lorenso(dot)com>
Cc: "Manfred Koizar" <mkoi-pg(at)aon(dot)at>, pgsql-general(at)postgresql(dot)org
Subject: Re: Serialization, Locking...implement processing Queue with a table
Date: 2003-05-14 14:33:51
Message-ID: 23782.1052922831@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"D. Dante Lorenso" <dante(at)lorenso(dot)com> writes:
> You can't do it this way because if this select IS successful,
> you'll still need to LOCK the row for the update.

That's why you should be using SELECT FOR UPDATE.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message greg 2003-05-14 14:44:04 Re: fomatting an interval (resend)
Previous Message Johnson, Shaunn 2003-05-14 14:19:05 tips and suggestions