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:pa...@gf.microolap.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
