Re: Is this typical psqlodbc behavior?

(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