Re: [HACKERS] [PATH] Idle in transaction cancellation

2010-10-19 Thread Robert Haas
On Tue, Oct 19, 2010 at 10:18 AM, Kevin Grittner wrote: > Andres Freund wrote: > >> Here is a proposed patch which enables cancellation of $subject. > > I'll take a look when I can, but it may be a couple weeks from now. How about adding it to https://commitfest.postgresql.org/action/commitfest_

Re: [HACKERS] [PATH] Idle in transaction cancellation

2010-10-19 Thread Kevin Grittner
Andres Freund wrote: > Here is a proposed patch which enables cancellation of $subject. Cool. Some enhancements we'd like to do to Serializable Snapshot Isolation (SSI), should the base patch make it in, would require this capability. > Currently it does *not* report any special error messa

[HACKERS] [PATH] Idle in transaction cancellation

2010-10-17 Thread Andres Freund
Hi all. Here is a proposed patch which enables cancellation of $subject. The problematic point about doing so is that the client is not expecting any messages from the server when its in an idle state during an transaction and that simply suppressing that message is not enough as ready for quer