Query Timeout Question

From: "feng(dot)zhou" <feng(dot)zhou(at)wellintech(dot)com>
To: "pgsql-sql" <pgsql-sql(at)postgresql(dot)org>
Subject: Query Timeout Question
Date: 2011-12-09 01:44:45
Message-ID: 201112090944451236494@wellintech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message feng.zhou 2011-12-09 01:58:23 Re: Query Timeout Question
Previous Message Craig Ringer 2011-12-09 01:13:11 Re: partitions versus databases