Re: PQstatus() detect change in connection...

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Matthew Hagerty <mhagerty(at)voyager(dot)net>
Cc: Mark Pritchard <mark(at)tangent(dot)net(dot)au>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PQstatus() detect change in connection...
Date: 2001-10-18 21:03:23
Message-ID: Pine.LNX.4.30.0110182005470.633-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Matthew Hagerty writes:

> I am trying to re-establish a connection, however, I cannot afford to issue
> a query to determine if the connection still exists.

But requesting that the server do something *is* the only way to know
whether it's still alive. Another question to ask, of course, would be,
why is your server always going down?

> I've been digging into the libpq code to see what is going on, maybe I can
> gleam a little hint or two there... Anyone know a good *fast* way to test
> if a socket is still valid?

Try to send or receive something.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2001-10-18 21:03:41 Re: compiling libpq++ on Solaris with Sun SPRO6U2 (fixed
Previous Message Peter Eisentraut 2001-10-18 21:03:03 Re: autoconf taking forever?