From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Mike Landl <mlandl(at)4glsol(dot)com>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Is this typical psqlodbc behavior? |
Date: | 2013-12-10 15:00:22 |
Message-ID: | 52A72C86.1080807@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Landl | 2013-12-10 15:11:28 | Re: Is this typical psqlodbc behavior? |
Previous Message | Mike Landl | 2013-12-10 13:06:41 | Re: Is this typical psqlodbc behavior? |