Re: PQstatus does not seem to work

Juan Backson <juanbackson@gmail.com> writes:
>  I used PQstatus(conn) function to check connection status, but I found that
> it still returns CONNECTION_OK even after postgres is restarted.  Does
> anyone know if there is another command that I can use to check connection
> status?

PQstatus isn't going to get updated until you try to do some operation
with the connection object.  Otherwise it wouldn't be a simple inquiry
function, but some exceedingly expensive operation involving attempting
to contact the server.

> What other solution is available to check whether a connection is still
> alive?

Send a query.

            regards, tom lane