lock timeout in pgsql 7.3.1
| От | Muhammad Shariq Muzaffar |
|---|---|
| Тема | lock timeout in pgsql 7.3.1 |
| Дата | |
| Msg-id | 20030208102013.53865.qmail@web41114.mail.yahoo.com обсуждение |
| Ответ на | Re: (Andrew McMillan <andrew@catalyst.net.nz>) |
| Список | 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
В списке pgsql-novice по дате отправления: