Re: odbc vs. libpq performance

From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
To: "Vilches, Alejandro" <alejandro(dot)vilches(at)intel(dot)com>, "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: odbc vs. libpq performance
Date: 2015-08-01 18:06:54
Message-ID: 55BD0ABE.5010800@iki.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On 07/31/2015 02:33 AM, Vilches, Alejandro wrote:
> I've continued looking into this and I discovered something: I
> figured out how to successfully set the SQL_ATTR_AUTOCOMMIT attribute
> to off. If you set it prior to establishing the connection, this
> setting is ignored and it defaults to on. If you set it after
> establishing the connection, then it does recognize the setting and
> it works as specified.
>
> The ODBC documentation specifies that this attribute can be set
> either before or after establishing the connection. If it's not
> accepting the setting before establishing the connection, is this an
> issue in the PostgreSQL ODBC driver?

A-ha! Yes, that's a bug in the driver. In fact, it was fixed back in
January:

http://www.postgresql.org/message-id/BY1PR0401MB143087AD121D0251C00E5045A85B0@BY1PR0401MB1430.namprd04.prod.outlook.com

That fix will be included in the next release.

- Heikki

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Dmitry Pogorelov 2015-08-02 19:13:06 PSQL iODBC driver on mac os x 10.10.3 (Yosemite)
Previous Message Christian Ullrich 2015-07-31 22:15:57 Re: Bugs related to getting @@identity