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

From Kevin Grittner
Subject Re: Cancelling idle in transaction state
Date
Msg-id 4B3B1557020000250002DA75@gw.wicourts.gov
Whole thread Raw
In response to Re: Cancelling idle in transaction state  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-hackers
Craig Ringer <craig@postnewspapers.com.au> wrote:
> It might be kind of handy if I could getWarnings() on the
> connection object without blocking so I could call it before I
> executed a statement on the connection ... but that'd always
> introduce a race between transaction cancellation/timeout and
> statement execution, so code must always be prepared to handle
> timeout/cancellation related failure anyway.
+1 (I think)
If I'm understanding this, it sounds to me like it would be most
appropriate for the NOTICE to generate a warning at the connection
level and for the next request to throw an exception in the format
suggested by Heikki -- which I think is what Craig is suggesting.
-Kevin


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: KNNGiST for knn-search (WIP)
Next
From: Alvaro Herrera
Date:
Subject: Re: test/example does not support win32.