Re: odbc vs. libpq performance

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