Re: How to stop a query - Mailing list pgsql-general

From Pavel Stehule
Subject Re: How to stop a query
Date
Msg-id 162867790909032253j51888524rc9ccd11d4f5f0f3b@mail.gmail.com
Whole thread Raw
In response to How to stop a query  (A B <gentosaker@gmail.com>)
Responses Re: How to stop a query  (younus <younus.essahli@gmail.com>)
List pgsql-general
hello

2009/9/4 A B <gentosaker@gmail.com>:
> Hi.
> How can I abort a query that I see is listed in
>
> select * from pg_stat_activity;
>

look on pg_cancel_backend function

http://www.postgresql.org/docs/8.2/static/functions-admin.html

regards
Pavel Stehule

> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: How to stop a query
Next
From: "A. Kretschmer"
Date:
Subject: Re: Moving avg using SQL