Search Postgresql Archives

libpq: Which functions may hang due to network issues?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I need to know which functions of libpq may "hang", depending on network issues. For some functions is seems to be clear, as they only work locally, other functions are clearly documented to wait on some network interaction. But for some functions, it is unclear on whether they are guaranteed to work locally without any possibility to hang or not, e.g. PQfinish(), PQstatus(), PQtransactionStatus(), etc.

Is there a complete list of methods that might wait for network communication?

Some background: I'm writing a C++ wrapper for libpq <https://github.com/taocpp/taopq/> and our applications, which are going to use that library, should never hang, even when there is a network problem and network communication breaks down for a connection. For that reason I'm using asynchronous calls for libpq only and I use timeouts when polling on the socket/FD. When a timeout occurs, I need to handle the situation in a reasonable manner. In my case, I currently close the connection by calling PQfinish(). Also, later I might call PQstatus() or PQtransactionStatus() in order to decide whether a connection is still valid and should be returned to the connection pool or if it needs to be discarded.







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux