Re: cancel query

From: Kris Jurka <books(at)ejurka(dot)com>
To: H A Prahalad <prahalad(at)MPI-SoftTech(dot)Com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: cancel query
Date: 2003-12-11 23:36:35
Message-ID: Pine.LNX.4.33.0312111835400.1627-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Florian G. Pflug 2003-12-12 03:24:32 Re: Strange permission problem regarding pg_settings
Previous Message Matt Gordon 2003-12-11 23:26:56 VACUUM ANALYZE -vs- ANALYZE on an insert-only table.