Re: psqlODBC 09.05.0300 (x86) - problem with SQL_QUERY_TIMEOUT

Поиск
Список
Период
Сортировка
От Tsunakawa, Takayuki
Тема Re: psqlODBC 09.05.0300 (x86) - problem with SQL_QUERY_TIMEOUT
Дата
Msg-id 0A3221C70F24FB45833433255569204D1F5B2E59@G01JPEXMBYT05
обсуждение исходный текст
Ответ на psqlODBC 09.05.0300 (x86) - problem with SQL_QUERY_TIMEOUT  ("Jan-Peter Seifert" <Jan-Peter.Seifert@gmx.de>)
Ответы Re: psqlODBC 09.05.0300 (x86) - problem with SQL_QUERY_TIMEOUT
Список pgsql-odbc
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Jan-Peter Seifert
> it looks like SQL_QUERY_TIMEOUT is on by default - causing dead connections
> with long running statements:
> 
> "SQLSTATE = 00000 Native Error = 26 Could not send Query(connection dead)"

No, SQL_QUERY_TIMEOUT is off by default.
I've just confirmed that "SET statement_timeout" is not issued when I executed "SELECT pg_sleep(60);" with isql command
ofthe unixODBC.  In addition, SQL_QUERY_TIMEOUT just terminates the query, retaining the database connection.  Your
messageseems to show that the connection was terminated.
 

Could you show the mylog output?

Regards
Takayuki Tsunakawa



В списке pgsql-odbc по дате отправления: