Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! - Mailing list pgsql-odbc

From Joshua D. Drake
Subject Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!
Date
Msg-id 56AA5348.60100@commandprompt.com
Whole thread Raw
In response to PostgreSQL: Autocommit through windows odbc driver doesnt work!!!  ("Venkatesan, Sekhar" <sekhar.venkatesan@emc.com>)
Responses Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!  ("Venkatesan, Sekhar" <sekhar.venkatesan@emc.com>)
List pgsql-odbc
On 01/28/2016 08:53 AM, Venkatesan, Sekhar wrote:

> Is the above issue fixed? Also in my use-case, I want to enable
> autocommit at odbc driver level but even that doesn’t work.
>
> The same application works in Linux OS when unix odbc driver is used.
> This seems to be specific to windows driver.
>
> Please shed some light on this. Do ask me further question if you have any.
>

By default PostgreSQL "autocommits". If it isn't in your case, your
driver is starting a transaction and not committing it.

Sincerely,

JD




--
Command Prompt, Inc.                  http://the.postgres.company/
                      +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.


pgsql-odbc by date:

Previous
From: "Venkatesan, Sekhar"
Date:
Subject: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!
Next
From: "Venkatesan, Sekhar"
Date:
Subject: Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!