X-Original-To: pgsql-sql@postgresql.org
Received: from lapcrew.com (pcp01360251pcs.benslm01.pa.comcast.net
	[68.81.104.121])
	by postgresql.org (Postfix) with ESMTP id 0385F47650C
	for <pgsql-sql@postgresql.org>; Thu,  6 Mar 2003 17:55:56 -0500 (EST)
Received: from Spooler by lapcrew.com (Mercury/32 v3.31) ID MO0003B6;
	5 Mar 03 17:51:15 -0600
Received: from spooler by lapcrew.com (Mercury/32 v3.31);
	5 Mar 03 17:51:05 -0600
Received: from [194.54.43.44] (146.145.38.11) by Lapcrew Mail Server
	(Mercury/32 v3.31) with ESMTP ID MG0003B5; 5 Mar 03 17:50:55 -0600
Subject: Cancelling Queries
From: Mark Mitchell <mark@lapcrew.com>
To: pgsql-sql@postgresql.org
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 (1.0.8-10) 
Date: 06 Mar 2003 18:25:29 -0500
Message-Id: <1046993130.21247.3.camel@sql.icnfull.com>
Mime-Version: 1.0
X-Archive-Number: 200303/171
X-Sequence-Number: 12211

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