From feng.zhou@wellintech.com Fri Dec  9 01:47:50 2011
Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 91F2414518E8
	for <pgsql-sql@postgresql.org>; 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 <feng.zhou@wellintech.com>) 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" <feng.zhou@wellintech.com>
To: "pgsql-sql" <pgsql-sql@postgresql.org>
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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18928"><LINK rel=stylesheet 
href="BLOCKQUOTE{margin-Top: 0px; margin-Bottom: 0px; margin-Left: 2em}"></HEAD>
<BODY style="MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt">
<DIV><FONT size=2 face=Verdana>Hi</FONT></DIV>
<DIV style="TEXT-INDENT: 2em">I set query timeout in code by using 
SQLSetStmtAttr ODBC API .</DIV>
<DIV style="TEXT-INDENT: 2em">&nbsp;</DIV>
<DIV 
style="TEXT-INDENT: 2em">SQLSetStmtAttr(&nbsp;StatementHandle,&nbsp;SQL_ATTR_QUERY_TIMEOUT,&nbsp;(SQLPOINTER)timeout,&nbsp;0&nbsp;) 
;</DIV>
<DIV style="TEXT-INDENT: 2em">SQLExecute(StatementHandle);</DIV>
<DIV style="TEXT-INDENT: 2em">&nbsp;</DIV>
<DIV style="TEXT-INDENT: 2em">But I find this setting&nbsp;has 
no&nbsp;effect.Before adding timeout setting, SQLExecute costs 47 seconds.After 
adding timeout, costing time is same.</DIV>
<DIV style="TEXT-INDENT: 2em">Postgres SQL version 8.4.2, ODBC driver 
8.4.2</DIV>
<DIV><FONT size=2 face=Verdana></FONT>&nbsp;</DIV>
<DIV align=left><FONT color=#c0c0c0 size=2 face=Verdana>2011-12-09 
</FONT></DIV><FONT size=2 face=Verdana>
<HR style="WIDTH: 122px; HEIGHT: 2px" align=left SIZE=2>

<DIV><FONT color=#c0c0c0 size=2 face=Verdana><SPAN>feng.zhou</SPAN> 
</FONT></DIV></FONT></BODY></HTML>

--=====003_Dragon765517754862_=====--




From feng.zhou@wellintech.com Fri Dec  9 02:01:33 2011
Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id D1AC314518EA
	for <pgsql-sql@postgresql.org>; Thu,  8 Dec 2011 22:01:33 -0400 (AST)
Received: from [119.161.170.176] (helo=MAIL.kingview.com)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <feng.zhou@wellintech.com>) id 1RYpmC-0005qC-6w
	for pgsql-sql@postgresql.org; Fri, 09 Dec 2011 02:01:33 +0000
Received: from zhoufeng ([172.16.3.16]) by MAIL.kingview.com with Microsoft
	SMTPSVC(6.0.3790.1830); Fri, 9 Dec 2011 09:38:56 +0800
Date: Fri, 9 Dec 2011 09:58:23 +0800
From: "feng.zhou" <feng.zhou@wellintech.com>
To: "pgsql-sql" <pgsql-sql@postgresql.org>
References: <201112090944451236494@wellintech.com>
Subject: Re: Query Timeout Question
Message-ID: <201112090958236709111@wellintech.com>
X-mailer: Foxmail 6, 15, 201, 22 [cn]
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=====003_Dragon215355750277_====="
X-OriginalArrivalTime: 09 Dec 2011 01:38:56.0140 (UTC)
	FILETIME=[50B254C0:01CCB613]
X-Host-Lookup-Failed: Reverse DNS lookup failed for 119.161.170.176 (failed)
X-Pg-Spam-Score: 2.2 (++)
X-Archive-Number: 201112/33
X-Sequence-Number: 36094


This is a multi-part message in MIME format.

--=====003_Dragon215355750277_=====
Content-Type: text/plain;
	charset="gb2312"
Content-Transfer-Encoding: base64

c29ycnksIHRpbWVvdXQgaXMgMTUgc2Vjb25kcw0KDQoNCjIwMTEtMTItMDkgDQoNCg0KDQpmZW5n
Lnpob3UgDQoNCg0KDQq3orz+yMujuiBmZW5nLnpob3UgDQq3osvNyrG85KO6IDIwMTEtMTItMDkg
IDA5OjI1OjQ5IA0KytW8/sjLo7ogcGdzcWwtc3FsIA0Ks63LzaO6IA0K1vfM4qO6IFtTUUxdIFF1
ZXJ5IFRpbWVvdXQgUXVlc3Rpb24gDQogDQpIaQ0KSSBzZXQgcXVlcnkgdGltZW91dCBpbiBjb2Rl
IGJ5IHVzaW5nIFNRTFNldFN0bXRBdHRyIE9EQkMgQVBJIC4NCg0KU1FMU2V0U3RtdEF0dHIoIFN0
YXRlbWVudEhhbmRsZSwgU1FMX0FUVFJfUVVFUllfVElNRU9VVCwgKFNRTFBPSU5URVIpdGltZW91
dCwgMCApIDsNClNRTEV4ZWN1dGUoU3RhdGVtZW50SGFuZGxlKTsNCg0KQnV0IEkgZmluZCB0aGlz
IHNldHRpbmcgaGFzIG5vIGVmZmVjdC5CZWZvcmUgYWRkaW5nIHRpbWVvdXQgc2V0dGluZywgU1FM
RXhlY3V0ZSBjb3N0cyA0NyBzZWNvbmRzLkFmdGVyIGFkZGluZyB0aW1lb3V0LCBjb3N0aW5nIHRp
bWUgaXMgc2FtZS4NClBvc3RncmVzIFNRTCB2ZXJzaW9uIDguNC4yLCBPREJDIGRyaXZlciA4LjQu
Mg0KDQoyMDExLTEyLTA5IA0KDQoNCg0KZmVuZy56aG91IA0K

--=====003_Dragon215355750277_=====
Content-Type: text/html;
	charset="gb2312"
Content-Transfer-Encoding: base64

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv
L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PWdi
MjMxMiIgaHR0cC1lcXVpdj1Db250ZW50LVR5cGU+DQo8TUVUQSBuYW1lPUdFTkVSQVRPUiBjb250
ZW50PSJNU0hUTUwgOC4wMC42MDAxLjE4OTI4Ij48TElOSyByZWw9c3R5bGVzaGVldCANCmhyZWY9
IkJMT0NLUVVPVEV7bWFyZ2luLVRvcDogMHB4OyBtYXJnaW4tQm90dG9tOiAwcHg7IG1hcmdpbi1M
ZWZ0OiAyZW19Ij4NCjxNRVRBIG5hbWU9R0VORVJBVE9SIGNvbnRlbnQ9Ik1TSFRNTCA2LjAwLjI5
MDAuMjE4MCI+DQo8U1RZTEU+QGZvbnQtZmFjZSB7DQoJZm9udC1mYW1pbHk6IMvOzOU7DQp9DQpA
Zm9udC1mYWNlIHsNCglmb250LWZhbWlseTogVmVyZGFuYTsNCn0NCkBmb250LWZhY2Ugew0KCWZv
bnQtZmFtaWx5OiBAy87M5TsNCn0NCkBwYWdlIFNlY3Rpb24xIHtzaXplOiA1OTUuM3B0IDg0MS45
cHQ7IG1hcmdpbjogNzIuMHB0IDkwLjBwdCA3Mi4wcHQgOTAuMHB0OyBsYXlvdXQtZ3JpZDogMTUu
NnB0OyB9DQpQLk1zb05vcm1hbCB7DQoJVEVYVC1KVVNUSUZZOiBpbnRlci1pZGVvZ3JhcGg7IFRF
WFQtQUxJR046IGp1c3RpZnk7IE1BUkdJTjogMGNtIDBjbSAwcHQ7IEZPTlQtRkFNSUxZOiAiVGlt
ZXMgTmV3IFJvbWFuIjsgRk9OVC1TSVpFOiAxMC41cHQNCn0NCkxJLk1zb05vcm1hbCB7DQoJVEVY
VC1KVVNUSUZZOiBpbnRlci1pZGVvZ3JhcGg7IFRFWFQtQUxJR046IGp1c3RpZnk7IE1BUkdJTjog
MGNtIDBjbSAwcHQ7IEZPTlQtRkFNSUxZOiAiVGltZXMgTmV3IFJvbWFuIjsgRk9OVC1TSVpFOiAx
MC41cHQNCn0NCkRJVi5Nc29Ob3JtYWwgew0KCVRFWFQtSlVTVElGWTogaW50ZXItaWRlb2dyYXBo
OyBURVhULUFMSUdOOiBqdXN0aWZ5OyBNQVJHSU46IDBjbSAwY20gMHB0OyBGT05ULUZBTUlMWTog
IlRpbWVzIE5ldyBSb21hbiI7IEZPTlQtU0laRTogMTAuNXB0DQp9DQpBOmxpbmsgew0KCUNPTE9S
OiBibHVlOyBURVhULURFQ09SQVRJT046IHVuZGVybGluZQ0KfQ0KU1BBTi5Nc29IeXBlcmxpbmsg
ew0KCUNPTE9SOiBibHVlOyBURVhULURFQ09SQVRJT046IHVuZGVybGluZQ0KfQ0KQTp2aXNpdGVk
IHsNCglDT0xPUjogcHVycGxlOyBURVhULURFQ09SQVRJT046IHVuZGVybGluZQ0KfQ0KU1BBTi5N
c29IeXBlcmxpbmtGb2xsb3dlZCB7DQoJQ09MT1I6IHB1cnBsZTsgVEVYVC1ERUNPUkFUSU9OOiB1
bmRlcmxpbmUNCn0NClNQQU4uRW1haWxTdHlsZTE3IHsNCglGT05ULVNUWUxFOiBub3JtYWw7IEZP
TlQtRkFNSUxZOiBWZXJkYW5hOyBDT0xPUjogd2luZG93dGV4dDsgRk9OVC1XRUlHSFQ6IG5vcm1h
bDsgVEVYVC1ERUNPUkFUSU9OOiBub25lOyBtc28tc3R5bGUtdHlwZTogcGVyc29uYWwtY29tcG9z
ZQ0KfQ0KRElWLlNlY3Rpb24xIHsNCglwYWdlOiBTZWN0aW9uMQ0KfQ0KVU5LTk9XTiB7DQoJRk9O
VC1TSVpFOiAxMHB0DQp9DQpCTE9DS1FVT1RFIHsNCglNQVJHSU4tVE9QOiAwcHg7IE1BUkdJTi1C
T1RUT006IDBweDsgTUFSR0lOLUxFRlQ6IDJlbQ0KfQ0KT0wgew0KCU1BUkdJTi1UT1A6IDBweDsg
TUFSR0lOLUJPVFRPTTogMHB4DQp9DQpVTCB7DQoJTUFSR0lOLVRPUDogMHB4OyBNQVJHSU4tQk9U
VE9NOiAwcHgNCn0NCjwvU1RZTEU+DQo8L0hFQUQ+DQo8Qk9EWSBzdHlsZT0iTUFSR0lOOiAxMHB4
OyBGT05ULUZBTUlMWTogdmVyZGFuYTsgRk9OVC1TSVpFOiAxMHB0Ij4NCjxESVY+PEZPTlQgY29s
b3I9IzAwMDA4MCBzaXplPTIgZmFjZT1WZXJkYW5hPnNvcnJ5LCB0aW1lb3V0IGlzIDE1IA0Kc2Vj
b25kczwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDA4MCBzaXplPTIgZmFjZT1W
ZXJkYW5hPjwvRk9OVD4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDA4MCBzaXpl
PTIgZmFjZT1WZXJkYW5hPjwvRk9OVD4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9I2Mw
YzBjMCBzaXplPTIgZmFjZT1WZXJkYW5hPjIwMTEtMTItMDkgPC9GT05UPjwvRElWPjxGT05UIA0K
Y29sb3I9IzAwMDA4MCBzaXplPTIgZmFjZT1WZXJkYW5hPg0KPEhSIHN0eWxlPSJXSURUSDogMTAw
cHgiIGFsaWduPWxlZnQgY29sb3I9I2I1YzRkZiBTSVpFPTE+DQo8L0ZPTlQ+DQo8RElWPjxGT05U
IGNvbG9yPSNjMGMwYzAgc2l6ZT0yIGZhY2U9VmVyZGFuYT48U1BBTj5mZW5nLnpob3U8L1NQQU4+
IA0KPC9GT05UPjwvRElWPg0KPEhSIGNvbG9yPSNiNWM0ZGYgU0laRT0xPg0KDQo8RElWPjxGT05U
IHNpemU9MiBmYWNlPVZlcmRhbmE+PFNUUk9ORz63orz+yMujujwvU1RST05HPiBmZW5nLnpob3Ug
PC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBzaXplPTIgZmFjZT1WZXJkYW5hPjxTVFJPTkc+t6LL
zcqxvOSjujwvU1RST05HPiAyMDExLTEyLTA5Jm5ic3A7IDA5OjI1OjQ5IA0KPC9GT05UPjwvRElW
Pg0KPERJVj48Rk9OVCBzaXplPTIgZmFjZT1WZXJkYW5hPjxTVFJPTkc+ytW8/sjLo7o8L1NUUk9O
Rz4gcGdzcWwtc3FsIDwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgc2l6ZT0yIGZhY2U9VmVyZGFu
YT48U1RST05HPrOty82jujwvU1RST05HPiA8L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIHNpemU9
MiBmYWNlPVZlcmRhbmE+PFNUUk9ORz7W98zio7o8L1NUUk9ORz4gW1NRTF0gUXVlcnkgVGltZW91
dCBRdWVzdGlvbiANCjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgc2l6ZT0yIGZhY2U9VmVyZGFu
YT48L0ZPTlQ+IDwvRElWPg0KPERJVj48Rk9OVCBzaXplPTIgZmFjZT1WZXJkYW5hPg0KPERJVj48
Rk9OVCBzaXplPTIgZmFjZT1WZXJkYW5hPkhpPC9GT05UPjwvRElWPg0KPERJViBzdHlsZT0iVEVY
VC1JTkRFTlQ6IDJlbSI+SSBzZXQgcXVlcnkgdGltZW91dCBpbiBjb2RlIGJ5IHVzaW5nIA0KU1FM
U2V0U3RtdEF0dHIgT0RCQyBBUEkgLjwvRElWPg0KPERJViBzdHlsZT0iVEVYVC1JTkRFTlQ6IDJl
bSI+Jm5ic3A7PC9ESVY+DQo8RElWIA0Kc3R5bGU9IlRFWFQtSU5ERU5UOiAyZW0iPlNRTFNldFN0
bXRBdHRyKCZuYnNwO1N0YXRlbWVudEhhbmRsZSwmbmJzcDtTUUxfQVRUUl9RVUVSWV9USU1FT1VU
LCZuYnNwOyhTUUxQT0lOVEVSKXRpbWVvdXQsJm5ic3A7MCZuYnNwOykgDQo7PC9ESVY+DQo8RElW
IHN0eWxlPSJURVhULUlOREVOVDogMmVtIj5TUUxFeGVjdXRlKFN0YXRlbWVudEhhbmRsZSk7PC9E
SVY+DQo8RElWIHN0eWxlPSJURVhULUlOREVOVDogMmVtIj4mbmJzcDs8L0RJVj4NCjxESVYgc3R5
bGU9IlRFWFQtSU5ERU5UOiAyZW0iPkJ1dCBJIGZpbmQgdGhpcyBzZXR0aW5nJm5ic3A7aGFzIA0K
bm8mbmJzcDtlZmZlY3QuQmVmb3JlIGFkZGluZyB0aW1lb3V0IHNldHRpbmcsIFNRTEV4ZWN1dGUg
Y29zdHMgNDcgc2Vjb25kcy5BZnRlciANCmFkZGluZyB0aW1lb3V0LCBjb3N0aW5nIHRpbWUgaXMg
c2FtZS48L0RJVj4NCjxESVYgc3R5bGU9IlRFWFQtSU5ERU5UOiAyZW0iPlBvc3RncmVzIFNRTCB2
ZXJzaW9uIDguNC4yLCBPREJDIGRyaXZlciANCjguNC4yPC9ESVY+DQo8RElWPjxGT05UIHNpemU9
MiBmYWNlPVZlcmRhbmE+PC9GT05UPiZuYnNwOzwvRElWPg0KPERJViBhbGlnbj1sZWZ0PjxGT05U
IGNvbG9yPSNjMGMwYzAgc2l6ZT0yIGZhY2U9VmVyZGFuYT4yMDExLTEyLTA5IA0KPC9GT05UPjwv
RElWPjxGT05UIHNpemU9MiBmYWNlPVZlcmRhbmE+DQo8SFIgc3R5bGU9IldJRFRIOiAxMjJweDsg
SEVJR0hUOiAycHgiIGFsaWduPWxlZnQgU0laRT0yPg0KDQo8RElWPjxGT05UIGNvbG9yPSNjMGMw
YzAgc2l6ZT0yIGZhY2U9VmVyZGFuYT48U1BBTj5mZW5nLnpob3U8L1NQQU4+IA0KPC9GT05UPjwv
RElWPjwvRk9OVD48L0ZPTlQ+PC9ESVY+PC9CT0RZPjwvSFRNTD4NCg==

--=====003_Dragon215355750277_=====--




From ringerc@ringerc.id.au Fri Dec  9 02:28:10 2011
Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 374BE14518EA
	for <pgsql-sql@postgresql.org>; Thu,  8 Dec 2011 22:28:10 -0400 (AST)
Received: from mail-yx0-f174.google.com ([209.85.213.174])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1RYqC0-0000he-Kg
	for pgsql-sql@postgresql.org; Fri, 09 Dec 2011 02:28:10 +0000
Received: by yenm11 with SMTP id m11so1687353yen.19
	for <pgsql-sql@postgresql.org>; Thu, 08 Dec 2011 18:27:55 -0800 (PST)
Received: by 10.236.139.199 with SMTP id c47mr8483638yhj.113.1323397675474;
	Thu, 08 Dec 2011 18:27:55 -0800 (PST)
Received: from ayaki.localdomain (124-169-254-28.dyn.iinet.net.au.
	[124.169.254.28])
	by mx.google.com with ESMTPS id u20sm19804291ank.9.2011.12.08.18.27.52
	(version=SSLv3 cipher=OTHER); Thu, 08 Dec 2011 18:27:54 -0800 (PST)
Message-ID: <4EE17226.40206@ringerc.id.au>
Date: Fri, 09 Dec 2011 10:27:50 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:7.0.1) Gecko/20110930 Thunderbird/7.0.1
MIME-Version: 1.0
To: "feng.zhou" <feng.zhou@wellintech.com>
CC: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Query Timeout Question
References: <201112090944451236494@wellintech.com>
In-Reply-To: <201112090944451236494@wellintech.com>
Content-Type: multipart/alternative;
	boundary="------------090109000704090103060500"
X-Pg-Spam-Score: -0.8 (/)
X-Archive-Number: 201112/34
X-Sequence-Number: 36095

This is a multi-part message in MIME format.
--------------090109000704090103060500
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 12/09/2011 09:44 AM, feng.zhou wrote:
> 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.

First: You're using a very old patch release with known bugs. Update to 
8.4.10 .

As for the timeout: PostgreSQL doesn't support query timeouts. It 
supports a session-level statement timeout. I don't know whether the 
ODBC driver uses that or not. Examine the ODBC `mylog' output after 
enabling psqlODBC debugging, and examine the server log after turning on 
query logging, so you can see what the ODBC driver actually asks the 
server for when you set a query timeout.

--
Craig Ringer

--------------090109000704090103060500
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    On 12/09/2011 09:44 AM, feng.zhou wrote:
    <blockquote cite="mid:201112090944451236494@wellintech.com"
      type="cite">
      <meta content="text/html; charset=ISO-8859-1"
        http-equiv="Content-Type">
      <meta name="GENERATOR" content="MSHTML 8.00.6001.18928">
      <link rel="stylesheet"
href="BLOCKQUOTE%7Bmargin-Top:%200px;%20margin-Bottom:%200px;%20margin-Left:%202em%7D">
      <div><font face="Verdana" size="2">Hi</font></div>
      <div style="TEXT-INDENT: 2em">I set query timeout in code by using
        SQLSetStmtAttr ODBC API .</div>
      <div style="TEXT-INDENT: 2em">&nbsp;</div>
      <div style="TEXT-INDENT: 2em">SQLSetStmtAttr(&nbsp;StatementHandle,&nbsp;SQL_ATTR_QUERY_TIMEOUT,&nbsp;(SQLPOINTER)timeout,&nbsp;0&nbsp;)
        ;</div>
      <div style="TEXT-INDENT: 2em">SQLExecute(StatementHandle);</div>
      <div style="TEXT-INDENT: 2em">&nbsp;</div>
      <div style="TEXT-INDENT: 2em">But I find this setting&nbsp;has
        no&nbsp;effect.Before adding timeout setting, SQLExecute costs 47
        seconds.After adding timeout, costing time is same.</div>
    </blockquote>
    <br>
    First: You're using a very old patch release with known bugs. Update
    to 8.4.10 .<br>
    <br>
    As for the timeout: PostgreSQL doesn't support query timeouts. It
    supports a session-level statement timeout. I don't know whether the
    ODBC driver uses that or not. Examine the ODBC `mylog' output after
    enabling psqlODBC debugging, and examine the server log after
    turning on query logging, so you can see what the ODBC driver
    actually asks the server for when you set a query timeout.<br>
    <br>
    --<br>
    Craig Ringer<br>
  </body>
</html>

--------------090109000704090103060500--



From feng.zhou@wellintech.com Fri Dec  9 02:54:07 2011
Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id D82511B7C3CA
	for <pgsql-sql@postgresql.org>; Thu,  8 Dec 2011 22:54:07 -0400 (AST)
Received: from [119.161.170.176] (helo=MAIL.kingview.com)
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <feng.zhou@wellintech.com>) id 1RYqb6-00015h-JE
	for pgsql-sql@postgresql.org; Fri, 09 Dec 2011 02:54:07 +0000
Received: from zhoufeng ([172.16.3.16]) by MAIL.kingview.com with Microsoft
	SMTPSVC(6.0.3790.1830); Fri, 9 Dec 2011 10:31:34 +0800
Date: Fri, 9 Dec 2011 10:51:02 +0800
From: "=?utf-8?B?ZmVuZy56aG91?=" <feng.zhou@wellintech.com>
To: "=?utf-8?B?Q3JhaWcgUmluZ2Vy?=" <ringerc@ringerc.id.au>
Cc: "=?utf-8?B?cGdzcWwtc3Fs?=" <pgsql-sql@postgresql.org>
References: <201112090944451236494@wellintech.com>
Subject: =?utf-8?B?UmU6IFJlOiBbU1FMXSBRdWVyeSBUaW1lb3V0IFF1ZXN0aW9u?=
Message-ID: <201112091051021748801@wellintech.com>
X-mailer: Foxmail 6, 15, 201, 22 [cn]
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=====003_Dragon377523267138_====="
X-OriginalArrivalTime: 09 Dec 2011 02:31:34.0625 (UTC)
	FILETIME=[AB4CE510:01CCB61A]
X-Host-Lookup-Failed: Reverse DNS lookup failed for 119.161.170.176 (failed)
X-Pg-Spam-Score: 2.4 (++)
X-Archive-Number: 201112/35
X-Sequence-Number: 36096


This is a multi-part message in MIME format.

--=====003_Dragon377523267138_=====
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: base64

VGhhbmtzIGZvciB5b3VyIHJlcGx5Lg0KaWYgdGltZW91dCBzZXR0aW5nIGRvZXNuJ3QgYmUgc3Vw
cG9ydGVkLCBIb3cgdG8gc29sdmUgdGhpcyBxdWVzdGlvbiB0aGF0IHRoZSBjbGllbnQgaXMgaHVu
ZyBmb3IgbG9uZyB0aW1lIHdoZW4gZXhlY3V0aW5nIHRpbWUtY29tc3VtaW5nIHF1ZXJ5IG9yIHF1
ZXJ5IGEgbG9ja2VkIHRhYmxlLg0KDQoNCjIwMTEtMTItMDkgDQoNCg0KDQpmZW5nLnpob3UgDQoN
Cg0KDQrlj5Hku7bkurrvvJogQ3JhaWcgUmluZ2VyIA0K5Y+R6YCB5pe26Ze077yaIDIwMTEtMTIt
MDkgIDEwOjA1OjQ0IA0K5pS25Lu25Lq677yaIGZlbmcuemhvdSANCuaKhOmAge+8miBwZ3NxbC1z
cWwgDQrkuLvpopjvvJogUmU6IFtTUUxdIFF1ZXJ5IFRpbWVvdXQgUXVlc3Rpb24gDQogDQpPbiAx
Mi8wOS8yMDExIDA5OjQ0IEFNLCBmZW5nLnpob3Ugd3JvdGU6IA0KSGkNCkkgc2V0IHF1ZXJ5IHRp
bWVvdXQgaW4gY29kZSBieSB1c2luZyBTUUxTZXRTdG10QXR0ciBPREJDIEFQSSAuDQoNClNRTFNl
dFN0bXRBdHRyKCBTdGF0ZW1lbnRIYW5kbGUsIFNRTF9BVFRSX1FVRVJZX1RJTUVPVVQsIChTUUxQ
T0lOVEVSKXRpbWVvdXQsIDAgKSA7DQpTUUxFeGVjdXRlKFN0YXRlbWVudEhhbmRsZSk7DQoNCkJ1
dCBJIGZpbmQgdGhpcyBzZXR0aW5nIGhhcyBubyBlZmZlY3QuQmVmb3JlIGFkZGluZyB0aW1lb3V0
IHNldHRpbmcsIFNRTEV4ZWN1dGUgY29zdHMgNDcgc2Vjb25kcy5BZnRlciBhZGRpbmcgdGltZW91
dCwgY29zdGluZyB0aW1lIGlzIHNhbWUuDQoNCkZpcnN0OiBZb3UncmUgdXNpbmcgYSB2ZXJ5IG9s
ZCBwYXRjaCByZWxlYXNlIHdpdGgga25vd24gYnVncy4gVXBkYXRlIHRvIDguNC4xMCAuDQoNCkFz
IGZvciB0aGUgdGltZW91dDogUG9zdGdyZVNRTCBkb2Vzbid0IHN1cHBvcnQgcXVlcnkgdGltZW91
dHMuIEl0IHN1cHBvcnRzIGEgc2Vzc2lvbi1sZXZlbCBzdGF0ZW1lbnQgdGltZW91dC4gSSBkb24n
dCBrbm93IHdoZXRoZXIgdGhlIE9EQkMgZHJpdmVyIHVzZXMgdGhhdCBvciBub3QuIEV4YW1pbmUg
dGhlIE9EQkMgYG15bG9nJyBvdXRwdXQgYWZ0ZXIgZW5hYmxpbmcgcHNxbE9EQkMgZGVidWdnaW5n
LCBhbmQgZXhhbWluZSB0aGUgc2VydmVyIGxvZyBhZnRlciB0dXJuaW5nIG9uIHF1ZXJ5IGxvZ2dp
bmcsIHNvIHlvdSBjYW4gc2VlIHdoYXQgdGhlIE9EQkMgZHJpdmVyIGFjdHVhbGx5IGFza3MgdGhl
IHNlcnZlciBmb3Igd2hlbiB5b3Ugc2V0IGEgcXVlcnkgdGltZW91dC4NCg0KLS0NCkNyYWlnIFJp
bmdlcg0K

--=====003_Dragon377523267138_=====
Content-Type: text/html;
	charset="utf-8"
Content-Transfer-Encoding: base64

77u/PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9u
YWwvL0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0
PXV0Zi04IiBodHRwLWVxdWl2PUNvbnRlbnQtVHlwZT4NCjxNRVRBIG5hbWU9R0VORVJBVE9SIGNv
bnRlbnQ9Ik1TSFRNTCA4LjAwLjYwMDEuMTg5MjgiPg0KPFNUWUxFPkBmb250LWZhY2Ugew0KCWZv
bnQtZmFtaWx5OiDlrovkvZM7DQp9DQpAZm9udC1mYWNlIHsNCglmb250LWZhbWlseTogVmVyZGFu
YTsNCn0NCkBmb250LWZhY2Ugew0KCWZvbnQtZmFtaWx5OiBA5a6L5L2TOw0KfQ0KQHBhZ2UgU2Vj
dGlvbjEge3NpemU6IDU5NS4zcHQgODQxLjlwdDsgbWFyZ2luOiA3Mi4wcHQgOTAuMHB0IDcyLjBw
dCA5MC4wcHQ7IGxheW91dC1ncmlkOiAxNS42cHQ7IH0NClAuTXNvTm9ybWFsIHsNCglURVhULUpV
U1RJRlk6IGludGVyLWlkZW9ncmFwaDsgVEVYVC1BTElHTjoganVzdGlmeTsgTUFSR0lOOiAwY20g
MGNtIDBwdDsgRk9OVC1GQU1JTFk6ICJUaW1lcyBOZXcgUm9tYW4iOyBGT05ULVNJWkU6IDEwLjVw
dA0KfQ0KTEkuTXNvTm9ybWFsIHsNCglURVhULUpVU1RJRlk6IGludGVyLWlkZW9ncmFwaDsgVEVY
VC1BTElHTjoganVzdGlmeTsgTUFSR0lOOiAwY20gMGNtIDBwdDsgRk9OVC1GQU1JTFk6ICJUaW1l
cyBOZXcgUm9tYW4iOyBGT05ULVNJWkU6IDEwLjVwdA0KfQ0KRElWLk1zb05vcm1hbCB7DQoJVEVY
VC1KVVNUSUZZOiBpbnRlci1pZGVvZ3JhcGg7IFRFWFQtQUxJR046IGp1c3RpZnk7IE1BUkdJTjog
MGNtIDBjbSAwcHQ7IEZPTlQtRkFNSUxZOiAiVGltZXMgTmV3IFJvbWFuIjsgRk9OVC1TSVpFOiAx
MC41cHQNCn0NCkE6bGluayB7DQoJQ09MT1I6IGJsdWU7IFRFWFQtREVDT1JBVElPTjogdW5kZXJs
aW5lDQp9DQpTUEFOLk1zb0h5cGVybGluayB7DQoJQ09MT1I6IGJsdWU7IFRFWFQtREVDT1JBVElP
TjogdW5kZXJsaW5lDQp9DQpBOnZpc2l0ZWQgew0KCUNPTE9SOiBwdXJwbGU7IFRFWFQtREVDT1JB
VElPTjogdW5kZXJsaW5lDQp9DQpTUEFOLk1zb0h5cGVybGlua0ZvbGxvd2VkIHsNCglDT0xPUjog
cHVycGxlOyBURVhULURFQ09SQVRJT046IHVuZGVybGluZQ0KfQ0KU1BBTi5FbWFpbFN0eWxlMTcg
ew0KCUZPTlQtU1RZTEU6IG5vcm1hbDsgRk9OVC1GQU1JTFk6IFZlcmRhbmE7IENPTE9SOiB3aW5k
b3d0ZXh0OyBGT05ULVdFSUdIVDogbm9ybWFsOyBURVhULURFQ09SQVRJT046IG5vbmU7IG1zby1z
dHlsZS10eXBlOiBwZXJzb25hbC1jb21wb3NlDQp9DQpESVYuU2VjdGlvbjEgew0KCXBhZ2U6IFNl
Y3Rpb24xDQp9DQpVTktOT1dOIHsNCglGT05ULVNJWkU6IDEwcHQNCn0NCjwvU1RZTEU+DQo8L0hF
QUQ+DQo8Qk9EWSBzdHlsZT0iTUFSR0lOOiAxMHB4OyBGT05ULUZBTUlMWTogdmVyZGFuYTsgRk9O
VC1TSVpFOiAxMHB0Ij4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDA4MCBzaXplPTIgZmFjZT1WZXJk
YW5hPlRoYW5rcyBmb3IgeW91ciByZXBseS48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGNvbG9y
PSMwMDAwODA+aWYgdGltZW91dCBzZXR0aW5nIGRvZXNuJ3QgYmUgc3VwcG9ydGVkLCBIb3cgdG8g
c29sdmUgDQp0aGlzIHF1ZXN0aW9uIHRoYXQgdGhlIGNsaWVudCBpcyBodW5nIGZvciBsb25nIHRp
bWUgd2hlbiBleGVjdXRpbmcgDQp0aW1lLWNvbXN1bWluZyBxdWVyeSBvciBxdWVyeSBhIGxvY2tl
ZCB0YWJsZS48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGNvbG9yPSMwMDAwODAgc2l6ZT0yIGZh
Y2U9VmVyZGFuYT48L0ZPTlQ+Jm5ic3A7PC9ESVY+DQo8RElWPjxGT05UIGNvbG9yPSMwMDAwODAg
c2l6ZT0yIGZhY2U9VmVyZGFuYT48L0ZPTlQ+Jm5ic3A7PC9ESVY+DQo8RElWPjxGT05UIGNvbG9y
PSNjMGMwYzAgc2l6ZT0yIGZhY2U9VmVyZGFuYT4yMDExLTEyLTA5IDwvRk9OVD48L0RJVj48Rk9O
VCANCmNvbG9yPSMwMDAwODAgc2l6ZT0yIGZhY2U9VmVyZGFuYT4NCjxIUiBzdHlsZT0iV0lEVEg6
IDEwMHB4IiBhbGlnbj1sZWZ0IGNvbG9yPSNiNWM0ZGYgU0laRT0xPg0KPC9GT05UPg0KPERJVj48
Rk9OVCBjb2xvcj0jYzBjMGMwIHNpemU9MiBmYWNlPVZlcmRhbmE+PFNQQU4+ZmVuZy56aG91PC9T
UEFOPiANCjwvRk9OVD48L0RJVj4NCjxIUiBjb2xvcj0jYjVjNGRmIFNJWkU9MT4NCg0KPERJVj48
Rk9OVCBzaXplPTIgZmFjZT1WZXJkYW5hPjxTVFJPTkc+5Y+R5Lu25Lq677yaPC9TVFJPTkc+IENy
YWlnIFJpbmdlciA8L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIHNpemU9MiBmYWNlPVZlcmRhbmE+
PFNUUk9ORz7lj5HpgIHml7bpl7TvvJo8L1NUUk9ORz4gMjAxMS0xMi0wOSZuYnNwOyAxMDowNTo0
NCANCjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgc2l6ZT0yIGZhY2U9VmVyZGFuYT48U1RST05H
PuaUtuS7tuS6uu+8mjwvU1RST05HPiBmZW5nLnpob3UgPC9GT05UPjwvRElWPg0KPERJVj48Rk9O
VCBzaXplPTIgZmFjZT1WZXJkYW5hPjxTVFJPTkc+5oqE6YCB77yaPC9TVFJPTkc+IHBnc3FsLXNx
bCA8L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIHNpemU9MiBmYWNlPVZlcmRhbmE+PFNUUk9ORz7k
uLvpopjvvJo8L1NUUk9ORz4gUmU6IFtTUUxdIFF1ZXJ5IFRpbWVvdXQgDQpRdWVzdGlvbiA8L0ZP
TlQ+PC9ESVY+DQo8RElWPjxGT05UIHNpemU9MiBmYWNlPVZlcmRhbmE+PC9GT05UPiA8L0RJVj4N
CjxESVY+PEZPTlQgc2l6ZT0yIGZhY2U9VmVyZGFuYT5PbiAxMi8wOS8yMDExIDA5OjQ0IEFNLCBm
ZW5nLnpob3Ugd3JvdGU6IA0KPEJMT0NLUVVPVEUgY2l0ZT1taWQ6MjAxMTEyMDkwOTQ0NDUxMjM2
NDk0QHdlbGxpbnRlY2guY29tIHR5cGU9ImNpdGUiPg0KICA8TUVUQSBuYW1lPUdFTkVSQVRPUiBj
b250ZW50PSJNU0hUTUwgOC4wMC42MDAxLjE4OTI4Ij48TElOSyByZWw9c3R5bGVzaGVldCANCiAg
aHJlZj0iQkxPQ0tRVU9URSU3Qm1hcmdpbi1Ub3A6JTIwMHB4OyUyMG1hcmdpbi1Cb3R0b206JTIw
MHB4OyUyMG1hcmdpbi1MZWZ0OiUyMDJlbSU3RCI+DQogIDxESVY+PEZPTlQgc2l6ZT0yIGZhY2U9
VmVyZGFuYT5IaTwvRk9OVD48L0RJVj4NCiAgPERJViBzdHlsZT0iVEVYVC1JTkRFTlQ6IDJlbSI+
SSBzZXQgcXVlcnkgdGltZW91dCBpbiBjb2RlIGJ5IHVzaW5nIA0KICBTUUxTZXRTdG10QXR0ciBP
REJDIEFQSSAuPC9ESVY+DQogIDxESVYgc3R5bGU9IlRFWFQtSU5ERU5UOiAyZW0iPiZuYnNwOzwv
RElWPg0KICA8RElWIA0KICBzdHlsZT0iVEVYVC1JTkRFTlQ6IDJlbSI+U1FMU2V0U3RtdEF0dHIo
Jm5ic3A7U3RhdGVtZW50SGFuZGxlLCZuYnNwO1NRTF9BVFRSX1FVRVJZX1RJTUVPVVQsJm5ic3A7
KFNRTFBPSU5URVIpdGltZW91dCwmbmJzcDswJm5ic3A7KSANCiAgOzwvRElWPg0KICA8RElWIHN0
eWxlPSJURVhULUlOREVOVDogMmVtIj5TUUxFeGVjdXRlKFN0YXRlbWVudEhhbmRsZSk7PC9ESVY+
DQogIDxESVYgc3R5bGU9IlRFWFQtSU5ERU5UOiAyZW0iPiZuYnNwOzwvRElWPg0KICA8RElWIHN0
eWxlPSJURVhULUlOREVOVDogMmVtIj5CdXQgSSBmaW5kIHRoaXMgc2V0dGluZyZuYnNwO2hhcyAN
CiAgbm8mbmJzcDtlZmZlY3QuQmVmb3JlIGFkZGluZyB0aW1lb3V0IHNldHRpbmcsIFNRTEV4ZWN1
dGUgY29zdHMgNDcgDQogIHNlY29uZHMuQWZ0ZXIgYWRkaW5nIHRpbWVvdXQsIGNvc3RpbmcgdGlt
ZSBpcyBzYW1lLjwvRElWPjwvQkxPQ0tRVU9URT48QlI+Rmlyc3Q6IA0KWW91J3JlIHVzaW5nIGEg
dmVyeSBvbGQgcGF0Y2ggcmVsZWFzZSB3aXRoIGtub3duIGJ1Z3MuIFVwZGF0ZSB0byA4LjQuMTAg
DQouPEJSPjxCUj5BcyBmb3IgdGhlIHRpbWVvdXQ6IFBvc3RncmVTUUwgZG9lc24ndCBzdXBwb3J0
IHF1ZXJ5IHRpbWVvdXRzLiBJdCANCnN1cHBvcnRzIGEgc2Vzc2lvbi1sZXZlbCBzdGF0ZW1lbnQg
dGltZW91dC4gSSBkb24ndCBrbm93IHdoZXRoZXIgdGhlIE9EQkMgZHJpdmVyIA0KdXNlcyB0aGF0
IG9yIG5vdC4gRXhhbWluZSB0aGUgT0RCQyBgbXlsb2cnIG91dHB1dCBhZnRlciBlbmFibGluZyBw
c3FsT0RCQyANCmRlYnVnZ2luZywgYW5kIGV4YW1pbmUgdGhlIHNlcnZlciBsb2cgYWZ0ZXIgdHVy
bmluZyBvbiBxdWVyeSBsb2dnaW5nLCBzbyB5b3UgY2FuIA0Kc2VlIHdoYXQgdGhlIE9EQkMgZHJp
dmVyIGFjdHVhbGx5IGFza3MgdGhlIHNlcnZlciBmb3Igd2hlbiB5b3Ugc2V0IGEgcXVlcnkgDQp0
aW1lb3V0LjxCUj48QlI+LS08QlI+Q3JhaWcgUmluZ2VyPEJSPjwvRk9OVD48L0RJVj48L0JPRFk+
PC9IVE1MPg0K

--=====003_Dragon377523267138_=====--