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