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

From Bruce Momjian
Subject Re: Cancelling idle in transaction state
Date
Msg-id 200901212046.n0LKkYS02600@momjian.us
Whole thread Raw
In response to Re: Cancelling idle in transaction state  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Cancelling idle in transaction state  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
Simon Riggs wrote:
> 
> On Wed, 2009-01-21 at 15:22 -0500, Bruce Momjian wrote:
> > Added to TODO:
> >     
> >     Allow administrators to cancel multi-statement idle
> >     transactions
> >     
> >         This allows locks to be released, but it is complex to report the
> >         cancellation back to the client.
> >     
> >             * http://archives.postgresql.org/pgsql-hackers/2008-12/msg01340.php 
> 
> This is part of Hot Standby.
> 
> The bug is on the TODO list.

Well, if it gets done for 8.4 then we can mark it completed;  it not it
will be there for 8.5.  The behavior is useful independent of hot
standby.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Cancelling idle in transaction state
Next
From: "Jonah H. Harris"
Date:
Subject: Re: [PATCH] EnableDisableTrigger Cleanup & Questions