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 по дате отправления: