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