Re: Degradation of performance when upgrade psqlodbc to 09.03.0400 - Mailing list pgsql-odbc

From Dang Minh Huong
Subject Re: Degradation of performance when upgrade psqlodbc to 09.03.0400
Date
Msg-id FBDEE456-7353-40C6-9EA5-A10B4295B30F@gmail.com
Whole thread Raw
In response to Re: Degradation of performance when upgrade psqlodbc to 09.03.0400  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
List pgsql-odbc
Hi Inoue-san,

Many thanks for your support and detail of explaination.
I understood and would like to close this topic.

Thanks and best regards,
bocap

Hi Dang,

On 2016/02/16 12:40, Dang Minh Huong wrote:
Hi Inoue-san,

I have tested some commits in revision 09.03.0100 and found that your "revise MSDTC support" patch made SQLSetConnectAttr issue.
Can you simply explain how does your patch cause that issue?

MSDTC support isn't directly related to the issue.

Original mistake is I defined autocommit_public field as a member of ConnInfo.
While revising CC_xxxx functions, I found it inappropriate to call SOCK_Constructor() (and CC_conninfo_init())
 in CC_Constructor(). and I removed them from CC_Constructor(). However this leaves inconsistent status
that autocommit_public is off but transact_status(internal autocommit status) is on..
    SQLSetConnectAttr(.., SQL_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF, ..) before SQLDriverConnect()
does nothing and leaves transact_status on.

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Issue with Money field using ODBC to Access database
Next
From: "Tsunakawa, Takayuki"
Date:
Subject: Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!