Re: reconnecting to DB after connection break - Mailing list pgadmin-hackers

From Chuck McDevitt
Subject Re: reconnecting to DB after connection break
Date
Msg-id 2106D8DC89010842BABA5CD03FEA40610100FB8145@EXVMBX018-10.exch018.msoutlookonline.net
Whole thread Raw
In response to reconnecting to DB after connection break  (Julius Tuskenis <julius.tuskenis@gmail.com>)
Responses Re: reconnecting to DB after connection break
List pgadmin-hackers
> -----Original Message-----
> From: pgadmin-hackers-owner@postgresql.org [mailto:pgadmin-hackers-
> owner@postgresql.org] On Behalf Of Julius Tuskenis
> Sent: Friday, August 21, 2009 3:16 AM
> To: pgadmin-hackers@postgresql.org
> Subject: [pgadmin-hackers] reconnecting to DB after connection break
> 
> Hello,
> 
> I'm thinking of changing pgAdmin so it would try to reconnect after its
> connection to server breaks. Is that ok with you? Maybe theres someone
> already dealing with the problem.
> 
> I think I could change pgConn::ExecuteVoid, pgConn::ExecuteScalar and
> pgConn::ExecuteSet methods so on connection to DB error there would be
> an attempt to reconnect. If someone knows a better solution - please,
> share it. :)
> 
> I'm new here so maybe someone would advice what "pitfalls" to avoid.
> 
> --
> Julius Tuskenis
> 

Sounds like a good idea.  The one pitfall I see is that any temporary tables the session had disappear when you
disconnectand reconnect, but I don't think there is anything to be done about that.
 



pgadmin-hackers by date:

Previous
From: Ângelo Marcos Rigo
Date:
Subject: ...
Next
From: Guillaume Lelarge
Date:
Subject: Re: reconnecting to DB after connection break