Guillaume Smet wrote:
> On Fri, Nov 28, 2008 at 6:45 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> Hm. People have complained of that fact from time to time in normal
>> usage as well. Should we simply change SIGINT handling to allow it to
>> cancel an idle transaction?
>>
>
> If this means that we would be able to able to easily rollback the
> current transaction of a backend stuck in "idle in transaction"
> status, a big +1.
>
>
Yes, I have had clients caught by this regularly (last time less than a
week ago), it would be a significant enhancement.
cheers
andrew