From: Mark Mitchell <mark@lapcrew.com>
To: jasiek@klaster.net
To: pgsql-sql@postgresql.org
Subject: Re: Cancelling Queries
Date: Thu, 06 Mar 2003 08:31:56 -0600
Message-ID: <3E675BDC.90703@lapcrew.com> (raw)
References: <1046993130.21247.3.camel@sql.icnfull.com>
<20030307052705.GA5440@serwer>
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@klaster.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@postgresql.org
>
>
>
--
Mark Mitchell
www.lapcrew.com
Registered Linux User # 299662
Mandrake 8.0 , RedHat 8.0
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mark@lapcrew.com, jasiek@klaster.net
Subject: Re: Cancelling Queries
In-Reply-To: <3E675BDC.90703@lapcrew.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox