Re: connection watchdog

Michael Kichanov wrote:
> Hi Postgres gurus!
>
> How can I check from C-program whether connection to pgsql
> engine still works or already lost?
> PQstatus() returns CONNECTION_OK even when backend process is killed
> by hands after connection is made.

> ps: Searching through pgsql-mail-lists archive and Faq gave nothing.


I think you can't know if a connection is ok before trying to send
a query to the server (IMHO)

If you really want to know before, you can send a simple query  (select '1')
and test the PGResult
(!= PGRES_COMMAND_OK or !=PGRES_TUPLES_OK or ==PGRES_BAD_RESPONSE or ==PGRES_FATAL_ERROR)