Re: Question about aborting

Поиск
Список
Период
Сортировка
От Durumdara
Тема Re: Question about aborting
Дата
Msg-id CAEcMXhnJsRBYABAoWLmszP6vhtcX_BHqFx+Z0zBOXF89QMeXag@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question about aborting  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы Re: Question about aborting
Список pgadmin-support
Hi!

I'm very-very thanks for it!
I was so tired yesterday, and I don't clicked on any connections, so
the buttons were greyed, and I could not see that there are buttons.
:-)

Client "start" column is too short. May you can save the columns width
to preserve the good size.

Thanks and regards:  dd



2011/7/6 Guillaume Lelarge <guillaume@lelarge.info>:
> On Wed, 2011-07-06 at 16:09 +0200, Durumdara wrote:
>> Dear Author!
>>
>> I need to know that which ways I have to abort a runaway query/stored procedure.
>>
>> As I saw, pgAdmin CAN abourt my own queries.
>> It is ok.
>>
>> But what's happens when:
>> - somebody (not me) started a query that have too less filter, and
>> becomes unlimited
>> - I started a query or stored proc what is buggy, and gets into
>> infinitive state because of wrong loops, but the TCP socket
>> disconnected by a failure, or wifi problem, so my session killed by
>> the server
>>
>> As I saw, pgAdmin have a monitoring tool which show me these queries.
>>
>> But have some tool in the pgAdmin with I can abort these runaway statements?
>>
>
> The server status tool can help you stop runaway queries. There's a
> button for that in the toolbar.
>
>
> --
> Guillaume
>  http://blog.guillaume.lelarge.info
>  http://www.dalibo.com
>
>


В списке pgadmin-support по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Question about aborting
Следующее
От: Defiant Challenged
Дата:
Сообщение: Using pgAgent w/o pgAdmin3 on linux