On Thu, Mar 06, 2003 at 08:31:56AM -0600, Mark Mitchell wrote:
> These are select queries that may have been keyed incorrectly that I
> need to cancel. So a transaction won't help in this case.
What about setting maximum query execution time in postgresql
configuration? There are some options help
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
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 a
