Postgres Pro
Downloads
Home   >   mailing lists

can we use PQstatus for knowing connection status - Mailing list pgsql-novice

From HK
Subject can we use PQstatus for knowing connection status
Date
Msg-id Pine.LNX.4.33.0306191133430.1916-100000@mallard.midascomm.com
Whole thread Raw
Responses Re: can we use PQstatus for knowing connection status
List pgsql-novice
Tree view 
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-

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Limiting processor power on queries
Next
From: Tom Lane
Date:
Subject: Re: can we use PQstatus for knowing connection status