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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
