| From: | Muhammad Shariq Muzaffar <shariq77(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | lock timeout in pgsql 7.3.1 |
| Date: | 2003-02-08 10:20:13 |
| Message-ID: | 20030208102013.53865.qmail@web41114.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I am having a little problem with STATEMENT_TIMEOUT, i
dont know why this is happening....
there are 2 users, first user have selected a record
using FOR UPDATE.
second user have selected 5 records using FOR UPDATE.
but when the second user tries to select the record
which is locked by the first user. Pgsql gives the
error "ERROR: query was cancelled." and rollbacks the
transaction which unlocks all the records locked by
the second user.
Is there any way that pgsql only gives the error and
keep the status of the transction as it is?
thanx in advance.
__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Iandé Coutinho | 2003-02-09 11:47:05 | simple one |
| Previous Message | Andrew McMillan | 2003-02-08 08:35:39 | Re: |