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(at)gf(dot)microolap(dot)com