Thanks for your reply.
if timeout setting doesn't be supported, How to solve this question that the
client is hung for long time when executing time-comsuming query or query a
locked table.
2011-12-09
feng.zhou
发件人： Craig Ringer
发送时间： 2011-12-09 10:05:44
收件人： feng.zhou
抄送：
sorry, timeout is 15 seconds
2011-12-09
feng.zhou
发件人： feng.zhou
发送时间： 2011-12-09 09:25:49
收件人： pgsql-sql
抄送：
主题： [SQL] Query Timeout Question
Hi
I set query timeout in code by using SQLSetStmtAttr ODBC API .
SQLSetStmtAttr( StatementHandle, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER
timeout, costing time is same.
Postgres SQL version 8.4.2, ODBC driver 8.4.2
2011-12-09
feng.zhou
Thanks, I will try it
2011-12-08
feng.zhou
发件人： Craig Ringer
发送时间： 2011-12-08 11:49:33
收件人： feng.zhou
抄送： pgsql-sql
主题： Re: [SQL] No response from the backend
On 12/08/2011 09:38 AM, feng.zhou wrote:
Thanks for your answer.
The client and server run on the same machine(Windows7
Thanks for your answer.
The client and server run on the same machine(Windows7). They are connected by
ODBC.The client accesses server by call ODBC API.Connection and query timeout
don't be set in the client.
2011-12-08
feng.zhou
发件人： Craig Ringer
发送时间： 2011-12-07 21:03:46
: SQL ERROR: GetSelectRowNum: Could not send
Query(connection dead);
Could not send Query(connection dead)
I don't know how to solve this problem. Someone can explain this problem
cause.Thanks
2011-12-07
feng.zhou
