Home > mailing lists

Feature: FOR UPDATE SKIP LOCKED - Mailing list pgsql-general

From	Jonathan Bond-Caron
Subject	Feature: FOR UPDATE SKIP LOCKED
Date	July 9, 2008 04:33:35
Msg-id	000c01c8e176$3a4a7d90$aedf78b0$@com Whole thread Raw
Responses	Re: Feature: FOR UPDATE SKIP LOCKED
List	pgsql-general

I’m been reading up on FOR UPDATE NOWAIT and it looks like it was added in 8.1.

How difficult is it to add FOR UPDATE SKIP LOCKED or something similar? (basically skip locked rows / oracle syntax)

More background here:

It would be quite useful to implement a database queue. Although FOR UPDATE NOWAIT and trying again can work as well as other techniques,

just skipping over the locks has its advantages (simplicity and zero wait)

From: Alvaro Herrera
Date: 09 July 2008, 04:28:06
Subject: Re: Getting source code for database objects

From: "Richard Broersma"
Date: 09 July 2008, 04:53:55
Subject: Re: Quick way to alter a column type?