| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-04-06 14:53:54 | Re: Database Name Case Sensitivity |
| Previous Message | Larry Holish | 2001-04-06 03:56:49 | foreign key violation |