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?
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 Eisentraut||Date: 2001-04-06 14:53:54|
|Subject: Re: Database Name Case Sensitivity|
|Previous:||From: Larry Holish||Date: 2001-04-06 03:56:49|
|Subject: foreign key violation|