Re: How to stop a query

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: A B <gentosaker(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to stop a query
Date: 2009-09-04 05:53:26
Message-ID: 162867790909032253j51888524rc9ccd11d4f5f0f3b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello

2009/9/4 A B <gentosaker(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2009-09-04 06:03:36 Re: Moving avg using SQL
Previous Message Guillaume Lelarge 2009-09-04 05:53:02 Re: How to stop a query