Re: Killing the backend to cancel a long waiting query - Mailing list pgsql-hackers

From Dave Page
Subject Re: Killing the backend to cancel a long waiting query
Date
Msg-id 50096.80.177.99.193.1064140018.squirrel@ssl.vale-housing.co.uk
Whole thread Raw
In response to Re: Killing the backend to cancel a long waiting query  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
It's rumoured that Christopher Kings-Lynne once said:
>> Wouldn't it be useful, though, to implement a "KILL" or "CANCEL" SQL
>> command that takes a backend ID as its argument (and, of course, does
>> the appropriate checks of whether you're a superuser or the owner of
>> the backend) and sends the appropriate signal to the target backend?
>>
>> That would make it possible for users to kill their own runaway
>> queries without having to run as whatever user PG is running as.
>
>
> It would be awesome for phpPGAdmin as well.  eg. Superusers would be
> able to cancel sql queries that gumby users are running, etc.

I'll second that for pgAdmin. I have times in the past where it would have
been useful on my own systems as well.
Regards, Dave.




pgsql-hackers by date:

Previous
From: "Heikki Tuuri"
Date:
Subject: Re: PostgreSQL not ACID compliant?
Next
From: Peter Eisentraut
Date:
Subject: Error message cleanup