Re: in transaction - safest way to kill - Mailing list pgsql-general

On Fri, Dec 5, 2008 at 11:25 PM, Glyn Astill <glynastill@yahoo.co.uk> 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