statement timeout with psqlODBC 09.05.300+ - Mailing list pgsql-odbc

From michael
Subject statement timeout with psqlODBC 09.05.300+
Date
Msg-id 1516895461336-0.post@n3.nabble.com
Whole thread Raw
Responses RE: statement timeout with psqlODBC 09.05.300+  (Richard Hetherington <hetheringtonrichard@hotmail.com>)
List 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 by date:

Previous
From: "Der Fluch"
Date:
Subject: Re: Can not execute DDL in SSIS.
Next
From: Richard Hetherington
Date:
Subject: RE: statement timeout with psqlODBC 09.05.300+