Postgres Pro
Downloads
Home   >   mailing lists

autocommit question - Mailing list pgsql-odbc

From
Subject autocommit question
Date
Msg-id OFA1CB81DA.D6EBAAF3-ONC1256EDA.0028A1CE-C1256EDA.00296AF7@flender.com
Whole thread Raw
List pgsql-odbc
Tree view

Hi,
I've tried to set autocommit to off with the following command in a c++ application

 SQLSetConnectAttr(hdbc, SQL_ATTR_AUTOCOMMIT, (SQLPOINTER)SQL_AUTOCOMMIT_OFF, SQL_NTS);

but that doesn't have the expected result.

Autocommit is still in state "ON" -> every command is handled as a single transaction ?

When using a explicit "BEGIN" -> real transaction handling is possible (as expected)

Why does SQLSetConnectAttr not cause the expected behavior ?

Best regards

tom

pgsql-odbc by date:

Previous
From: "Antonio Pennino"
Date:
Subject: Re: problem with CVS version
Next
From: mattandmel@gmail.com (Matt Ittigson)
Date:
Subject: Re: psqlODBC / install / WinXP