Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2])
	by postgresql.org (Postfix) with ESMTP id 605FC475873
	for <pgsql-sql@postgresql.org>; Fri, 12 Jul 2002 00:57:59 -0400 (EDT)
Received: from oasis.net.au (guardian [210.8.139.5])
	by water.oasis.net.au (8.9.3/100.1) with ESMTP id PAA15437
	for <pgsql-sql@postgresql.org>; Fri, 12 Jul 2002 15:11:21 +1000
X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5]
	claimed to be oasis.net.au
Message-ID: <3D2E6283.4090101@oasis.net.au>
Date: Fri, 12 Jul 2002 15:00:51 +1000
From: Rudi Starcevic <rudi@oasis.net.au>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.1a+) Gecko/20020711
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Query kill
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200207/175
X-Sequence-Number: 8554

Hello,

If I write a query that is inefficient or in an eternal loop how
do I stop it without restarting the postmaster ?

I can see many postmaster processed appearing in the output of the 'ps' 
command.
Do I need to stop/kill them all or can I stop just the query I want ?

Thanks heaps
Rudi.