Skip site navigation (1) Skip section navigation (2)

ODBC Autocommit behaviour?

From: "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC Autocommit behaviour?
Date: 2008-09-03 12:27:38
Message-ID: 20080903122738.155380@gmx.net (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello,

what is the official behaviour of AUTOCOMMIT=ON and AUTOCOMMIT=OFF in psqlODBC? 'ON' should commit every statement sent at once I guess. Does 'OFF' only start new transactions if needed and react to eplicit ROLLBACKs and COMMITs?
How is it connected to "Level of rollback on errors" in the ODBC Advanced options? Which setting has higher priority?

Where can I find exact documentation? I could'n find much information on http://psqlodbc.projects.postgresql.org or is this not the projects official site?

Could you tell me, please?

Thank you very much,

Peter

-- 
Psssst! Schon das coole Video vom GMX MultiMessenger gesehen?
Der Eine für Alle: http://www.gmx.net/de/go/messenger03

pgsql-odbc by date

Next:From: Richard BroersmaDate: 2008-09-03 12:40:03
Subject: Re: using M$ ACCESS pass-thru query keep on asking for odbc authentication
Previous:From: ocaDate: 2008-09-03 03:33:55
Subject: using M$ ACCESS pass-thru query keep on asking for odbcauthentication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group