Re: Is this typical psqlodbc behavior? - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Is this typical psqlodbc behavior?
Date
Msg-id 52A72C86.1080807@tpf.co.jp
Whole thread Raw
In response to Re: Is this typical psqlodbc behavior?  ("Mike Landl" <mlandl@4glsol.com>)
Responses Re: Is this typical psqlodbc behavior?  ("Mike Landl" <mlandl@4glsol.com>)
Re: Is this typical psqlodbc behavior?  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-odbc
(2013/12/10 22:06), Mike Landl wrote:
> Thank you. Can you tell me how I can disable the savepoints using odbc.ini
> in Linux?
> Apologies if I should know this, I haven't been able to find it.
> Is there a list of odbc.ini options that psqlodbc recognizes anywhere?

Please look at *Level of rollback on errors* section at
docs/config.html.
Specify PROTOCOL option with the level of rollback on errors
    PROTOCOL=7.4[-(0|1|2)]
0:driver does nothing
1:driver rollback the transaction entirely
2:driver rollback the statement

The default is 2 for recent versions of PostgreSQL servers and
the driver issues SAVEPOINT commands beforehand to rollback the
subsequent statement on errors.

regards,
Hiroshi Inoue




--
I am using the free version of SPAMfighter.
SPAMfighter has removed 788 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Do you have a slow PC? Try a Free scan
http://www.spamfighter.com/SLOW-PCfighter?cid=sigen


pgsql-odbc by date:

Previous
From: "Mike Landl"
Date:
Subject: Re: Is this typical psqlodbc behavior?
Next
From: "Mike Landl"
Date:
Subject: Re: Is this typical psqlodbc behavior?