Re: Default for "Level of rollback on errors"

From: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
To: Huong Dangminh <huo-dangminh(at)ys(dot)jp(dot)nec(dot)com>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>, Hiroshi Yanagisawa <hir-yanagisawa(at)ut(dot)jp(dot)nec(dot)com>
Subject: Re: Default for "Level of rollback on errors"
Date: 2016-07-02 10:58:36
Message-ID: 57779E5C.6030608@dream.email.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>
>

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2016-07-02 11:18:07 Re: Build broken with nmake since ea74e47
Previous Message Venkatesan, Sekhar 2016-07-02 10:36:51 Re: Updateable cursors ODBC configuration Partition Issue