Обсуждение: How can I stop a long running query
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
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. > > >
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