cancel while waiting for a lock - how?

From: Kevin English <kenglish(at)4csoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: cancel while waiting for a lock - how?
Date: 2000-12-06 14:58:14
Message-ID: d2hs2t0lb8agn7urgbfsg21qtgalgct82t@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-12-06 15:26:42 Re: syntax of outer join in 7.1devel
Previous Message Poul L. Christiansen 2000-12-06 14:26:22 syntax of outer join in 7.1devel