Re: how to cancel a query ? - Mailing list pgsql-admin

From Andreas Schmitz
Subject Re: how to cancel a query ?
Date
Msg-id 200212051350.44846.a.schmitz@cityweb.de
Whole thread Raw
In response to Re: how to cancel a query ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: how to cancel a query ?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
On Wednesday 04 December 2002 17:47, Tom Lane wrote:
> Andreas Schmitz <a.schmitz@cityweb.de> writes:
> > ist there any way to cancel a user query as dba ?
>
> Send a SIGINT to the backend process running that query, eg
>
>     kill -INT <pid>
>
> This has the same effect as a user-requested cancel (eg ^C in psql).
>

What about an implementation into the command structure ?

regards

-andreas

--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email a.schmitz@cityweb.de


pgsql-admin by date:

Previous
From: "Rajesh Kumar Mallah."
Date:
Subject: Re: how to alter sequence.
Next
From: Tim Frank
Date:
Subject: Re: PAM