From: | Dang Minh Huong <kakalot49(at)gmail(dot)com> |
---|---|
To: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
Cc: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Degradation of performance when upgrade psqlodbc to 09.03.0400 |
Date: | 2016-02-16 22:25:51 |
Message-ID: | FBDEE456-7353-40C6-9EA5-A10B4295B30F@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tsunakawa, Takayuki | 2016-02-17 03:01:03 | Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! |
Previous Message | Adrian Klaver | 2016-02-16 14:41:53 | Re: Issue with Money field using ODBC to Access database |