I am writing an application on Windows that connects to the local database
through psqlodbc. I want to make it automatically detect connection loss
and reconnect. When I manually stop the database service and try to send a
query, I get an error with sqlstate HY000 and the message ' server closed
the connection unexpectedly'. Shouldn't sqlstate be something like 08S01?
Also SQLGetConnectAttr with SQL_ATTR_CONNECTION_DEAD does not produce the
right value. The value it returns is always SQL_CD_FALSE.