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

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

From
"Jackson, DeJuan"
Date:
> 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

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

From
Tom Lane
Date:
>> 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