From: | joy chen <chenjoy_us(at)yahoo(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | question about timeout attributes |
Date: | 2004-12-10 18:06:19 |
Message-ID: | 20041210180619.94269.qmail@web21428.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi there,
I am playing out these timeout attributes:
SQL_ATTR_CONNECTION_TIMEOUT and
SQL_ATTR_QUERY_TIMEOUT. Basically I set the connection
timeout to 1 sec after a connection is made and query
timeout to 1 sec after a statement handle is
allocated. And then I did the following:
1. lock a table (say dummy) manually in exclusive
mode.
2. run my program which try to query this dummy table
using the odbc interface with the same statement
handle above.
To my understanding, if these timeout features are
supported correctly. My query should timeout after 1
sec. But in my test, the query just waits there
forever.
My question is therefore whether these timeout
attributes are supported by the postgresql odbc driver
at all or there is a problem in my test.
Any suggestions or recommendations are highly
appreciated.
Thank you
Joy
__________________________________
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250
From | Date | Subject | |
---|---|---|---|
Next Message | Scot Loach | 2004-12-12 16:43:27 | Re: question about timeout attributes |
Previous Message | Stephen Frost | 2004-12-08 03:24:59 | Re: ODBC Rewrite |