Re: Can PQstatus() be used by Application to check connection to postgres periodically?

Hello, sujayr06.

You wrote:

s> Hello All,

s>            My application has to do a real time data upload to PostgreSQL
s> server. 

s>            Every time i have to do a real time upload, i do not wish to open
s> new connection.
s>            I want to open a connection once [when my application comes up]
s> and periodically check if the connection is active.
s>            Can PQstatus() be used by application to check the status of the
s> connection already established?

s>            If PQstatus() cannot be used, does PostgreSQL provide alternate
s> interface to check the status of the                     connection.

s>           Note : I do not wish to open connection on every real time upload
s> as its an overhead for the application.

s>            Appreciate any help!

You may use PQtransactionStatus for this purpose
(http://www.postgresql.org/docs/9.1/static/libpq-status.html)

s> WBR,
s> Sujay 

s>          


s>            

s> --
s> View this message in context:
s>
http://postgresql.1045698.n5.nabble.com/Can-PQstatus-be-used-by-Application-to-check-connection-to-postgres-periodically-tp5462315p5462315.html
s> Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.




-- 
With best wishes,Pavel                          mailto:pavel@gf.microolap.com