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/
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 |