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

From Christopher Kings-Lynne
Subject Re: Killing the backend to cancel a long waiting query
Date
Msg-id 20030921142434.S61926-100000@houston.familyhealth.com.au
Whole thread Raw
In response to Re: Killing the backend to cancel a long waiting query  (Kevin Brown <kevin@sysexperts.com>)
Responses Re: Killing the backend to cancel a long waiting query  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-hackers
> 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.

Chris




pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Can't build latest CVS:
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Can't build latest CVS: