From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | jasiek(at)klaster(dot)net |
Cc: | Mark Mitchell <mark(at)lapcrew(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Cancelling Queries |
Date: | 2003-03-07 18:26:38 |
Message-ID: | 200303071826.h27IQc205082@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Libpq has PQrequestCancel() which does cancels, but I don't see it in
DBD. Maybe someone can make a patch. ;-)
---------------------------------------------------------------------------
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
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-03-07 18:31:47 | Re: problem with subselect |
Previous Message | Andreas Pflug | 2003-03-07 18:10:14 | Re: How to notice column changes in trigger |