Re: Cancelling Queries

These are select queries that may have been keyed incorrectly that I
need to cancel. So a transaction won't help in this case.

- Mark

jasiek(at)klaster(dot)net wrote:

>On Thu, Mar 06, 2003 at 06:25:29PM -0500, Mark Mitchell wrote:
>
>
>>I have a Perl program that executes PostgreSQL queries through DBI.
>>Is there any way to cancel a query once its started. If I could at least
>>somehow get the PID of the child process postmaster starts I could kill
>>that.
>>
>>This may be a better question for the Perl programming list but I
>>thought I'd ask you guys too
>>
>>Mark Mitchell
>>
>>
>Use transactions.
>Just before query finish you can confirm query (commit) or cancel it
>(rollback)
>
>Regards,
>Tomasz Myrta
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
>

--
Mark Mitchell
www.lapcrew.com
Registered Linux User # 299662
Mandrake 8.0 , RedHat 8.0