Default for "Level of rollback on errors"

From: Huong Dangminh <huo-dangminh(at)ys(dot)jp(dot)nec(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Cc: Hiroshi Yanagisawa <hir-yanagisawa(at)ut(dot)jp(dot)nec(dot)com>
Subject: Default for "Level of rollback on errors"
Date: 2016-06-28 13:05:24
Message-ID: 75DB81BEEA95B445AE6D576A0A5C9E9364D2DB59@BPXM05GP.gisp.nec.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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.

Thanks and best regards,
Dang Minh Huong
NEC Solution Innovators, Ltd.
http://www.nec-solutioninnovators.co.jp/en/

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Venkatesan, Sekhar 2016-06-28 13:26:49 Re: PostgreSQL: SQLSetPos fails with SetPos update return error.
Previous Message Pavel Raiskup 2016-06-28 08:52:45 Re: psqlODBC 09.05.0200 Released