Re: BUG #1943: Lock A row with the option NoWait

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Mathias Laurent <e1lauren(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1943: Lock A row with the option NoWait
Date: 2005-10-25 05:31:39
Message-ID: 20051025053139.GA1727@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Oct 06, 2005 at 17:42:25 +0100,
Mathias Laurent <e1lauren(at)hotmail(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1943
> Logged by: Mathias Laurent
> Email address: e1lauren(at)hotmail(dot)com
> PostgreSQL version: 8.0
> Operating system: windows
> Description: Lock A row with the option NoWait
> Details:
>
> Hello,
> I would like to know how to make a lock on a row with the instruction
> NoWait. Because it is not possible with "Select .... For Update" which don't
> allow NoWait Behind !
> Also if it is not possible to do this thing, could it be develloped in a
> next version ?

This will be a new feature in 8.1. See the 8.1 release notes:
http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Patrick Kik 2005-10-25 10:22:10 BUG #1997: Grammar error in phpPgAdmin 3.1
Previous Message Tom Lane 2005-10-25 04:37:39 Re: BUG #1993: Adding/subtracting negative time intervals