| From: | "ling" <ling(at)gd-soft(dot)com> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | FOR UPDATE NOWAIT |
| Date: | 2003-05-30 01:29:00 |
| Message-ID: | 001901c3264b$11b149e0$1501a8c0@userlingzj |
| Views: | Raw Message | Whole Thread | 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.
---------
ling
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Terence Ng | 2003-05-30 05:09:20 | Re: PHP vs Cold Fusion vs Zope |
| Previous Message | ghaverla | 2003-05-29 23:20:22 | Re: MD5 done. Thanks! |