Thread: ODBC and pgpool
View Single Post

   
  #4 (permalink)  
Old 04-16-2008, 02:49 AM
Mark Morgan Lloyd
 
Posts: n/a
Default Re: ODBC and pgpool

Many thanks. Not the most desirable situation but at least it's a clear answer.

My current situation is that I'm using Delphi on the clients, this has
data-aware components that adopt undefined (or at the very least inconvenient
:-) states when no longer connected to the underlying database. However I have
aother reasons to want to discard these, so this becomes just one more factor to
consider in the redesign.

Peter Eisentraut wrote:
>
> Mark Morgan Lloyd wrote:
> > If a Win-32 system connects via ODBC to pgpool, does the system
> > running pgpool have to be permanently running or can it be rebooted
> > without deranging open but quiescent connections?

>
> No, your application will have to be able to reconnect if the connection
> is lost by reason of the "server" disappearing or having been moved.


--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply With Quote