Tim Tassonis <[EMAIL PROTECTED]> writes: > I try to reproduce the situation tomorrow and will also check on any > odbc_errmsg() messages and the postmaster log.
OK. A couple of comments: the only timeout within Postgres itself is statement_timeout, which I think wouldn't apply to your situation even if you had it set (but I might be wrong). We have also heard reports of firewalls dropping idle connections, but in that scenario you'd not still have a working connection afterwards. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match