On Fri, Dec 5, 2008 at 11:25 PM, Glyn Astill <glynastill@xxxxxxxxxxx> wrote: > > select pg_cancel_backend(<pid>); No, pg_cancel_backend() cancels only *query*, and doesn't kill idle in transaction. I think that killing the backend (idle in transaction) with SIGTERM is better way. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
