2012/2/8 Pavel Golub <pa...@microolap.com>: > 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)
Only if you don't care about getting the right answer. Neither PQstatus() nor PQtransactionStatus() make any attempt to determine whether the server is still there; they just return the cached status of the connection, without any system calls whatsoever. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
