Re: <IDLE> in transaction - safest way to kill

select pg_cancel_backend(<pid>);

--- On Fri, 5/12/08, William Temperley <willtemperley(at)gmail(dot)com> wrote:

> From: William Temperley <willtemperley(at)gmail(dot)com>
> Subject: [GENERAL] <IDLE> in transaction - safest way to kill
> To: pgsql-general(at)postgresql(dot)org
> Date: Friday, 5 December, 2008, 2:08 PM
> Hi all
>
> Could anyone tell me what's the best thing to with idle
> transactions
> that are holding locks?
>
> I just killed the process as I wanted to get on with some
> work. I'm
> just not sure this is a good idea when we go into
> production.
>
> Cheers
>
> Will T
>
> --
> Sent via pgsql-general mailing list
> (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general