Re: Default for "Level of rollback on errors" - Mailing list pgsql-odbc

From Inoue, Hiroshi
Subject Re: Default for "Level of rollback on errors"
Date
Msg-id 57779E5C.6030608@dream.email.ne.jp
Whole thread Raw
In response to Default for "Level of rollback on errors"  (Huong Dangminh <huo-dangminh@ys.jp.nec.com>)
Responses Re: Default for "Level of rollback on errors"  (Huong Dangminh <huo-dangminh@ys.jp.nec.com>)
List pgsql-odbc
Hi,

On 2016/06/28 22:05, Huong Dangminh wrote:
> Hi,
>
> I have one question about DSN setting dialog.
> Following phenomenon have confirmed in 09.05.0200, 09.05.0210, 09.03.0300 version.
>
> After create a DSN by ODBC Datasource Administrator,
> Setting of "Level of rollback on errors" in "Advanced Options (DataSource)"(Page 2)
> is in not checked state.
> In this state it work as "Statement" setting, it mean that queries in BEGIN block
> will be surrounded with SAVEPOINT statement before executed.
>
> But when "Level of rollback on errors" setting is in not checked state,
> if I press "OK" button (in "Advanced Options (DataSource)"(Page 2) dialog)
> and reconfirm "Level of rollback on errors". The setting become "Transaction"
>  (rollback the whole transaction).
>
> So, is it intentionally sir?
>
> I wonder if what is exactly the default for this setting.

Hmm you are right.
It would be fixed in the next release.

Thanks.
Hiroshi Inoue
>
>


pgsql-odbc by date:

Previous
From: "Venkatesan, Sekhar"
Date:
Subject: Re: Updateable cursors ODBC configuration Partition Issue
Next
From: "Inoue, Hiroshi"
Date:
Subject: Re: Build broken with nmake since ea74e47