pgAdmin hang on connection drop/reconnect

From: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin hang on connection drop/reconnect
Date: 2008-03-24 17:04:25
Message-ID: 1206378265.25401.21.camel@maciek-desktop.sm.truviso.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Maciek Sakrejda 2008-03-24 18:43:38 building on 1.8.1 on windows / build-wxmsw.bat problem
Previous Message Dave Page 2008-03-23 15:13:50 Re: [pgadmin-support] New, strange error message