Skip site navigation (1) Skip section navigation (2)

FOR UPDATE NOWAIT

From: Peter Lovell <petel0(at)yahoo(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: FOR UPDATE NOWAIT
Date: 2001-04-06 08:14:58
Message-ID: 20010406081458.28027.qmail@web13704.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
When attempting to lock a row in a table in Oracle
using SELECT...FOR UPDATE it is possible to append
NOWAIT to the query to ensure that the query is
cancelled if the row is already locked.

I could really do with a feature like this, and so:
-  Does either this feature exist?
-  If not, is it possible to determine if a row is    
 locked before using SELECT...FOR UPDATE?
-  If not is it possible to set a 'waiting' time for
queries that are waiting for a row lock to expire?
-  Is there a transacation time out?

Thanks.

--
Pete Lovell

____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

pgsql-novice by date

Next:From: Peter EisentrautDate: 2001-04-06 14:53:54
Subject: Re: Database Name Case Sensitivity
Previous:From: Larry HolishDate: 2001-04-06 03:56:49
Subject: foreign key violation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group