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.
-- Simon Riggs www.2ndQuadrant.comPostgreSQL Training, Services and Support