Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 91F2414518E8 for ; Thu, 8 Dec 2011 21:47:50 -0400 (AST) Received: from [119.161.170.176] (helo=MAIL.kingview.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RYpYx-0008Sh-W3 for pgsql-sql@postgresql.org; Fri, 09 Dec 2011 01:47:49 +0000 Received: from zhoufeng ([172.16.3.16]) by MAIL.kingview.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 9 Dec 2011 09:25:17 +0800 Date: Fri, 9 Dec 2011 09:44:45 +0800 From: "feng.zhou" To: "pgsql-sql" Subject: Query Timeout Question Message-ID: <201112090944451236494@wellintech.com> X-mailer: Foxmail 6, 15, 201, 22 [cn] Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====003_Dragon765517754862_=====" X-OriginalArrivalTime: 09 Dec 2011 01:25:17.0578 (UTC) FILETIME=[68CBAEA0:01CCB611] X-Host-Lookup-Failed: Reverse DNS lookup failed for 119.161.170.176 (failed) X-Pg-Spam-Score: 3.0 (+++) X-Archive-Number: 201112/32 X-Sequence-Number: 36093 This is a multi-part message in MIME format. --=====003_Dragon765517754862_===== Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 --=====003_Dragon765517754862_===== Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: 7bit
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
--=====003_Dragon765517754862_=====--