cancel while waiting for a lock - how? - Mailing list pgsql-general

From Kevin English
Subject cancel while waiting for a lock - how?
Date
Msg-id d2hs2t0lb8agn7urgbfsg21qtgalgct82t@4ax.com
Whole thread Raw
List pgsql-general
Hi,
I notice that in version 7.0.3 there has been a fix to allow cancel
while waiting for a lock.  What I would like to know is how to cancel
an sql statement that is waiting for a lock or how to even know
that I am waiting for lock. Better yet, how can I specify that I
would prefer the the statement to return immediately (without aborting
the whole transaction) if it cannot aquire the required locks. I would
like to be able to do this using libpq.

Thanks
Kevin English

pgsql-general by date:

Previous
From: ZeugswetterA@Wien.Spardat.at (Zeugswetter Andreas SB)
Date:
Subject: AW: [HACKERS] beta testing version
Next
From: markw@mohawksoft.com (mlw)
Date:
Subject: [HACKERS] Function returning tuples.