Feature: FOR UPDATE SKIP LOCKED

From: "Jonathan Bond-Caron" <jbondc(at)gmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Feature: FOR UPDATE SKIP LOCKED
Date: 2008-07-09 03:45:26
Message-ID: 000c01c8e176$3a4a7d90$aedf78b0$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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:

http://forge.mysql.com/worklog/task.php?id=3597

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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-07-09 04:02:02 Re: Getting source code for database objects
Previous Message Artacus 2008-07-09 03:24:01 Getting source code for database objects