Yes i understand it would be difficult but i would like to develop this patch as it would create huge flexibility in psqlODBC and help a lot to its users.
I have read a lot about you as a passionate psqlODBC developer , I would request if you can share some knowledge document about psqlODBC or design details so that i can create more effective patch.
Can we have similar functionality added in psqlODBC as in unmodified code when nowait==False it waits for "infinite duration" ,Instead If we have a configured timed wait,anybody can configure it as per their requirement.
Yeah, that would be nice. The ODBC standard way to do it is to set the SQL_ATTR_QUERY_TIMEOUT attribute with SQLSetStmtAttr. It's not supported by the psqlodbc driver, however. It probably would be quite difficult to implement, but patches are welcome..
You could also do "set statement_timeout=2" to set a timeout in the server, but that wouldn't help with network problems.