Re: Killing the backend to cancel a long waiting query

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

Предыдущее
От: "Heikki Tuuri"
Дата:
Сообщение: Re: PostgreSQL not ACID compliant?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Error message cleanup