Re: cancel query

On Tue, 9 Dec 2003, H A Prahalad wrote:

>
> Hello,
> 	I want to know whether PostgreSQL support cancel() [cancel
> JDBCStatement]. I want to abort a long running query issued/executed by a
> java application using JDBC driver to connect to the database. Thanks.
>

The JDBC driver does support Statement.cancel(), but the tricky part is
that you need to have access to the Statement object that issued the
original query.  You can't just open a new connection and cancel another
query.

Kris Jurka