Re: Canceling/Killing a query

You can use "pg_ctl kill" on the commandline, or you can use the
function pg_cancel_backend(), see
http://developer.postgresql.org/docs/postgres/functions-admin.html#FUNCT
IONS-ADMIN-SIGNAL-TABLE


//Magnus


>-----Original Message-----
>From: [email protected] 
>[mailto:[email protected]] On Behalf Of 
>Vitaly Belman
>Sent: den 12 december 2004 14:40
>To: PostgreSQL Win32
>Subject: [pgsql-hackers-win32] Canceling/Killing a query
>
>
>Is there a way to kill a query that was ran from PHP?
>
>In Linux you could kill the process, but what can I do in windows?
>Restarting the service is hardly the best option.
>
>-- 
> ICQ: 1912453
> AIM: VitalyB1984
> MSN: [email protected]
> Yahoo!: VitalyBe
>
>---------------------------(end of 
>broadcast)---------------------------
>TIP 8: explain analyze is your friend
>

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org