Re: Cancelling Queries

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