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

From Huong Dangminh
Subject Default for "Level of rollback on errors"
Date
Msg-id 75DB81BEEA95B445AE6D576A0A5C9E9364D2DB59@BPXM05GP.gisp.nec.co.jp
Whole thread Raw
Responses Re: Default for "Level of rollback on errors"
List 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/


pgsql-odbc by date:

Previous
From: Pavel Raiskup
Date:
Subject: Re: psqlODBC 09.05.0200 Released
Next
From: "Venkatesan, Sekhar"
Date:
Subject: Re: PostgreSQL: SQLSetPos fails with SetPos update return error.