Re: Cancelling idle in transaction state - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Cancelling idle in transaction state
Date
Msg-id 20100103105531.GB11071@svana.org
Whole thread Raw
In response to Re: Cancelling idle in transaction state  (Kris Jurka <books@ejurka.com>)
Responses Re: Cancelling idle in transaction state  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Fri, Jan 01, 2010 at 03:31:58PM -0500, Kris Jurka wrote:
> The JDBC driver does want "cancel if active" behavior.  The JDBC API
> specifies Statement.cancel() where Statement is running one particular
> backend query.  So it really does want to cancel just that one query.
> Already this is tough because of the asynchronous nature of the cancel
> protocol and the inability to say exactly what should be cancelled.

I've looked in the JDBC documentation but I don't quickly see how they
expect this to work with transactions. What is being proposed seems to
me to be:

If statement active:  put transaction in aborted state
If no statement active:  do nothing

However, I see that the documentation wants to be able to abort a
*specific* statement, which is not being proposed here. Can that be
implemented on top of the current proposal?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: So do we really *need* those substring() ops in tab-completion queries?
Next
From: Tatsuo Ishii
Date:
Subject: Re: exec_execute_message crash