pgAdmin hang on connection drop/reconnect

[Maciek Sakrejda <msakrejda(at)truviso(dot)com>]

pgAdmin hangs when connection drops while trying to execute a query

Steps to reproduce:

1. Open SQL query pane
2. Type "SELECT pg_sleep(10);"
3. Shut down postgres in less than ten seconds (the query in pgAdmin
will error out)
4. Start postgres
5. Re-run the query

Result: pgAdmin will hang.

Expected behavior: Ideally, automagically reconnect and re-run the
query. Telling the user the connection dropped and having to reconnect
manually would also be acceptable, even if the query pane has to be
closed.

I suppose this is more important to us at Truviso than postgres users in
general (since long-running queries are our bread and butter), but this
should probably have a more user-friendly behavior anyway. Please let me
know if you need more details.

Thanks,
-- 
Maciek Sakrejda
Truviso, Inc.
http://www.truviso.com