Thread: How can I stop a long running query

How can I stop a long running query

From
"Angelo Misto'"
Date:

 I'm using Postgesql 7.1 and the jdbc driver jdbc7.1-1.1
 to talk to the database from java/swing application (jdk1.3.1) I

How can I stop a long running query?
The method cancel of class Statement seems working well,
but if I look the process status I see a postmaster process
running in background.

Thank you,
Angelo.

--
Angelo Misto` - Osservatorio Astronomico di Brera
Via Bianchi 46. Merate, Lecco, Italy - Tel.: 039/9991159









Re: How can I stop a long running query

From
Barry Lind
Date:
Angelo,

What do you mean by 'running in background'?  Cancel just aborts the
current query, the process and connection are still available for
additional queries.

--Barry

Angelo Misto' wrote:

> I'm using Postgesql 7.1 and the jdbc driver jdbc7.1-1.1
> to talk to the database from java/swing application (jdk1.3.1) I
>
>How can I stop a long running query?
>The method cancel of class Statement seems working well,
>but if I look the process status I see a postmaster process
>running in background.
>
>Thank you,
>Angelo.
>
>
>





Re: How can I stop a long running query

From
tony
Date:
On Mon, 2002-06-24 at 08:46, Angelo Misto' wrote:

> How can I stop a long running query?

Shoot it! =:-D

I use Webmin and connect to the server to terminate runaway queries.
Sometimes terminate sometimes kill. Kill the query not the postmaster!

Cheers

Tony
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html