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
thiscase.<br /><br /> - Mark<br /><br /><a class="moz-txt-link-abbreviated"
href="mailto:jasiek@klaster.net">jasiek@klaster.net</a>wrote:<br /><blockquote cite="mid20030307052705.GA5440@serwer"
type="cite"><prewrap="">On Thu, Mar 06, 2003 at 06:25:29PM -0500, Mark Mitchell wrote: </pre><blockquote
type="cite"><prewrap="">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   </pre></blockquote><pre wrap="">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 <a class="moz-txt-link-abbreviated"
href="mailto:majordomo@postgresql.org">majordomo@postgresql.org</a>
 </pre></blockquote><br /><pre class="moz-signature" cols="$mailwrapcol">-- 
Mark Mitchell
<a class="moz-txt-link-abbreviated" href="http://www.lapcrew.com">www.lapcrew.com</a>
Registered Linux User # 299662
Mandrake 8.0 , RedHat 8.0
</pre><br />