Were you doing that over a vpn connection by chance?
Pgadmin frequently will get disconnect for me if it is idle for a while
when using it through a vpn connection. I will still be logged into the
vpn and able to browse my network folders after it has happened so I
know the vpn connection was not completely lost.
Mike
On Thu, 2006-11-30 at 23:16 +0100, Erwin Brandstetter wrote:
> Hi developers! Hi Dave!
>
> Testing 1.6.1 rev: 5709, client Win XP. Host Debian Sarge, PG 8.1.4
>
> A new version is out. Congratulations on your good work! :)
>
> I have run a few tests, found nothing bad, and used it for serious work.
> Found something bad though, when I was not looking. Here is what I did:
>
> From within the edit grid I applied a new filter.
> _Many_ rows were fetched, so it took a _long_ time before (new) data
> would be displayed.
> Got distracted, came back, edited filter and reapplied before the result
> of the previous filter had been displayed.
> pgAdmin crashed on me, and with it a dozen windows with unfinished work. :(
> Now, I know that a note is being displayed at the bottom left:
> "Refreshing data, please wait" while data is being fetched. But it is
> easily overlooked, and that's what I did.
>
> Trying to reproduce this (no difference if I apply a new filter from
> within or I open the edit grid with the filter option), it crashes
> occasionally. Most of the time I just get an error of this kind:
>
> An error has occurred:
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request
>
>
> Possible cure:
> Lock the edit grid while waiting for data (hourglass?), or at least
> prevent pgAdmin from crashing.
> But please don't leave this footgun loaded for the occasionally poor of
> sight, like me.
>
>
> Regards
> Erwin
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq