Are you accessing a remote, network connected server for your testing?
If so, are you causing a network outage by disconnecting your network connection?
I have been seeing for a long time, on windows clients, that pgAdmin does not behave very nicely when, for any reason, the connection is no longer up.
The reason for the connection not being up is typically that I am accessing a database that is remote, and potentially sitting behind at least a couple of layers of firewall or nat, which have their own ideas about how long to allow a connection mappings across them valid and functioning, so it's not really something I have direct control over, and in any case, we're talking about how pgAdmin reacts to such an occurrence, not how to avoid the problem.
The bottom line is that in windows, when pgAdmin discovers that the connection has been broken, pgAdmin most often ends up having to be killed off and restarted. I've even gotten to the point of not even trying to have it attempt to reconnect, because it seems that this can fail as well.
This issue appears to affect not only the table edit grid tool, but the main app as well. Not sure about the sql query tool.
Either way, the problem as a whole is quite annoying when it happens.
Don't get me wrong, pgAdmin is great! But, this is one of it's rough edges.
From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Guillaume Lelarge
Sent: Thursday, June 09, 2011 11:50 AM
To: Herouth Maoz
Subject: Re: [pgadmin-support] Is 1.14 supposed to behave differently when it loses connection?
On Thu, 2011-06-09 at 11:48 +0300, Herouth Maoz wrote:
> Look, it's very simple, there are two separate problems here.
> 1. In the query tool, I don't get any questions asked. Just error messages in the message area, no alerts, not anything. I'd attach a screen capture but it's over 42M for just a few frames, I don't have video expertise enough to make it smaller. But I feel strange that I have to provide proof anyways. It's very simple. I click the "run query" button, and I get the errors that I mentioned below. That's it.
> 2. In the table tool, it of course doesn't ask me anything. I get it - it isn't supposed to. It just gives me error messages. Fine, but then I close the query tool and the table tool, bring up the main window, try to reconnect (I first refresh the existing connection, it then tells me it lost the connection and asks to re-connect. I allow it to reconnect. It refreshes the connection) - and then it either gets stuck in watch-cursor and behaves funny (e.g. I can bring up a table window but I can't resize the columns) or - more often than not - it crashes completely.
> So one problem is that the query tool is not allowing me to reconnect. Another problem is that pgAdmin crashes after I reconnect a disconnected connection in the main window.
> I am not hiding any steps from you. This is the full and complete information that I have!
I don't reproduce it when I follow your steps. I don't know what more I
Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
To make changes to your subscription:
In response to
pgadmin-support by date
|Next:||From: Guillaume Lelarge||Date: 2011-06-15 19:55:00|
|Subject: Re: Is 1.14 supposed to behave differently when
it loses connection?|
|Previous:||From: Einertson, Joseph T (USA E D EA)||Date: 2011-06-15 13:04:25|
|Subject: Using view data tool breaks graphics on XP|