statement timeout with psqlODBC 09.05.300+

Поиск
Список
Период
Сортировка
От michael
Тема statement timeout with psqlODBC 09.05.300+
Дата
Msg-id 1516895461336-0.post@n3.nabble.com
обсуждение исходный текст
Ответы RE: statement timeout with psqlODBC 09.05.300+  (Richard Hetherington <hetheringtonrichard@hotmail.com>)
Список pgsql-odbc
Hi,

This ticket is related to
http://www.postgresql-archive.org/BUG-odbc-statement-timeout-gets-set-to-30000-td5992591.html

The client using the ODBC Driver is on Windows 7, must be x86 compatible,
and connect to a 9.6 postgresql database.
from 09.05.300+ version of the ODBC driver x86 (tested up to 10.01), queries
which used to work fine with drivers 08.x now throw "ERROR: canceling
statement due to statement timeout;"

It seems that there is now a default setting for statement timeout coming
with 9.5+ versions of the driver (less than 1 mn), and I did not find any
way to change this setting.
I tried to find a key in the Windows Registry Database or to set the timeout
in the connection string but did not find good documentation and did not
succeeded.
Any help woul be appreciated




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-odbc-f2186591.html


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

Предыдущее
От: "Der Fluch"
Дата:
Сообщение: Re: Can not execute DDL in SSIS.
Следующее
От: Richard Hetherington
Дата:
Сообщение: RE: statement timeout with psqlODBC 09.05.300+