Postgres Pro
Downloads
Home   >   mailing lists

Re: Serialization, Locking...implement processing Queue with a table - Mailing list pgsql-general

From Tom Lane
Subject Re: Serialization, Locking...implement processing Queue with a table
Date
Msg-id 23782.1052922831@sss.pgh.pa.us
Whole thread Raw
In response to Re: Serialization, Locking...implement processing Queue with a table  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-general
Tree view 
"D. Dante Lorenso" <dante@lorenso.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

pgsql-general by date:

Previous
From: "Jay O'Connor"
Date:
Subject: Re: executables when upgrading
Next
From: Bob Wheldon
Date:
Subject: AFAIK