Re: Query Timeout Question - Mailing list pgsql-sql

From feng.zhou
Subject Re: Query Timeout Question
Date
Msg-id 201112090958236709111@wellintech.com
Whole thread Raw
In response to Query Timeout Question  ("feng.zhou" <feng.zhou@wellintech.com>)
List pgsql-sql
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, 0 ) ;
SQLExecute(StatementHandle);
 
But I find this setting has no effect.Before adding timeout setting, SQLExecute costs 47 seconds.After adding timeout, costing time is same.
Postgres SQL version 8.4.2, ODBC driver 8.4.2
 
2011-12-09

feng.zhou

pgsql-sql by date:

Previous
From: "feng.zhou"
Date:
Subject: Query Timeout Question
Next
From: Craig Ringer
Date:
Subject: Re: Query Timeout Question