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