select pg_cancel_backend(<pid>);
--- On Fri, 5/12/08, William Temperley <[EMAIL PROTECTED]> wrote: > From: William Temperley <[EMAIL PROTECTED]> > Subject: [GENERAL] <IDLE> in transaction - safest way to kill > To: pgsql-general@postgresql.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
