Re: Killing the backend to cancel a long waiting query

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Killing the backend to cancel a long waiting query
Дата
Msg-id 20030921142434.S61926-100000@houston.familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Killing the backend to cancel a long waiting query  (Kevin Brown <kevin@sysexperts.com>)
Ответы Re: Killing the backend to cancel a long waiting query  ("Dave Page" <dpage@vale-housing.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Can't build latest CVS:
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Can't build latest CVS: