On Wed, 2011-06-15 at 11:10 -0500, Belbin, Peter wrote:
> Guillaume,
>
> Are you accessing a remote, network connected server for your testing?
>
Nope.
> If so, are you causing a network outage by disconnecting your network connection?
>
Nope.
All I can do is a fast stop of postgres. Which does the same. Connection
is drop without notice.
> 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
potentiallysitting behind at least a couple of layers of firewall or nat, which have their own ideas about how long to
allowa connection mappings across them valid and functioning, so it's not really something I have direct control over,
andin 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
endsup 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
querytool.
>
> 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.
>
I understand that. But I have no answer for you.
--
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com