Re: How to stop a query

Le vendredi 4 septembre 2009 à 07:37:20, A B a écrit :
> Hi.
> How can I abort a query that I see is listed in
>
> select * from pg_stat_activity;

You have to do:

  SELECT pg_cancel_backend(pid of the postgres process);


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com