can we use PQstatus for knowing connection status

From: HK <harikrishnan(at)midascomm(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: can we use PQstatus for knowing connection status
Date: 2003-06-19 06:14:17
Message-ID: Pine.LNX.4.33.0306191133430.1916-100000@mallard.midascomm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,
I am using libpq for connecting from a C program to postgres
7.1.3. And i am using asyncronous query processing. Suppose i sent a query
and while processing is on, the postmaster is stopped (for simulating a pg
crash). Now if i use the PQstatus (conn) i am unable to get the actual
status. It still says the connection is OK. Then how can we detect the pg
crash.
Is it proper to reply upon PQstatus for knowing the status of the
connection. Please can some body help me.
TIA.
--
regards,
hari
__
/ / __ _ _ _ _ __ __ -o)
/ /__ / / / \\// //_// \\ \\/ / /\\\\ Making things happen
/____/ /_/ /_/\\/ /___/ /_/\\_\\ _\\_v-

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-06-19 13:53:29 Re: can we use PQstatus for knowing connection status
Previous Message Tom Lane 2003-06-19 02:46:46 Re: Limiting processor power on queries