On Tue, Apr 8, 2014 at 11:28 AM, Hannes Erven <hannes@erven.at> wrote:
> On 2014-04-08 15:27, Vick Khera wrote:
> [...]
>>
>> Problem 2: you cannot have a second process skip over locked rows.
>
>
>
> In fact, you can: use "FOR UPDATE NOWAIT" and catch any errors.
>
> e.g. SELECT * FROM jobqueue WHERE id=? FOR UPDATE NOWAIT
That's not really skipping over the locked rows and returning the next
row, that's bailing out and retrying.