statement timeout with psqlODBC 09.05.300+

From: michael <michael(dot)michaud(at)ign(dot)fr>
To: pgsql-odbc(at)postgresql(dot)org
Subject: statement timeout with psqlODBC 09.05.300+
Date: 2018-01-25 15:51:01
Message-ID: 1516895461336-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Richard Hetherington 2018-01-25 17:15:23 RE: statement timeout with psqlODBC 09.05.300+
Previous Message Der Fluch 2018-01-19 15:27:47 Re: Can not execute DDL in SSIS.