RE: [QUESTIONS] Best way to halt an unending query.

Started by Jackson, DeJuanover 27 years ago2 messages
#1Jackson, DeJuan
djackson@cpsgroup.com

Marc Howard Zuckman wrote:

On Wed, 29 Apr 1998, Marc Howard Zuckman wrote:

What's the best way to halt the query? Since I have a backup done
just before initiating the delete, I can just reload the database
if necessary.

I was too pessimistic. Ten minutes after I posted this message, the
query terminated normally

But it is a very good question. I was reluctant to ask about it, but
since it already happened... How do I cancel gracefully?

--Gene

Why don't we ask the experts?

-DEJ

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Jackson, DeJuan (#1)
Re: [HACKERS] RE: [QUESTIONS] Best way to halt an unending query.

But it is a very good question. I was reluctant to ask about it, but
since it already happened... How do I cancel gracefully?

Right now, you don't. We're working on adding a cancel facility though.
I've got the libpq (client) side done, now Bruce just has to make the
backend respond ;-)

regards, tom lane