Re: Cancelling idle in transaction state

On Sun, 2010-01-03 at 11:55 +0100, Martijn van Oosterhout wrote:
> 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?

That would require Statement-level abort, which we don't have.

--
Simon Riggs www.2ndQuadrant.com