| From: | Leon <leon(at)udmnet(dot)ru> |
|---|---|
| To: | "'pgsql-general(at)hub(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Cannot cancel LOCK TABLE |
| Date: | 1999-07-27 14:29:12 |
| Message-ID: | 379DC238.429A2E75@udmnet.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi!
There we have a need of canceling LOCK TABLE requests
which fail to lock the table in a given time. Scenario is following:
try to issue a lock on a table, wait for a given time for a completion
ot this lock request, and, if it fails, cancel a lock request and go on
processing other queries. A little experimenting showed that LOCK TABLE
requests cannot be canceled. They just sit in the queue of queries
and don't let other queries to be processed. How can I overcome
that? The piece of code where I try to cancel lock request:
if (difftime(t1,t0) > LOCK_WAIT_TIMEOUT)
{
printf("\nTimeout waiting for lock. Try again.\n");
PQrequestCancel(conn);
PQsendQuery(conn,"rollback");
return 1;
}
--
Leon.
---------
"This may seem a bit weird, but that's okay, because it is weird." -
Perl manpage.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Mascari | 1999-07-27 16:41:51 | Re: [GENERAL] Problem Compiling C-functions |
| Previous Message | Finn Kettner | 1999-07-27 13:45:56 | Re: [GENERAL] PHP and Postgresql 6.5.1 |