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
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. |