Thread: [ psqlodbc-Bugs-1000563 ] Rollback in manual transaction
Bugs item #1000563, was opened at 2006-02-22 12:23 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000563&group_id=1000125 Category: None Group: None >Status: Closed Resolution: None Priority: 3 Submitted By: Lorenzo Marcone (marcone) >Assigned to: Hiroshi Inoue (hinoue) Summary: Rollback in manual transaction Initial Comment: Postgres 8.1 either Windows or linux psqlODBC 08.01.0200 .Net Framework 1.1 in particular Visual Basic In Notes: psqlODBC 08.01.0106 I read: ... 3) doesn't call rollback in autocommit off or in manual transaction ... But Executing a statement in a transaction which gives an error causes an implicit rollback of the transaction and the closeof the connection. Sample code: Dim cnt As New Odbc.OdbcConnection"Driver={PostgreSQL Unicode}; Server=****; Database=test_ado; Uid=postgres; Password=****;BoolsAsChar=0; Parse=0; UniqueIndex=1; TextAsLongVarchar=1; LowerCaseIdentifier=1") Dim tra As Odbc.OdbcTransaction Dim sSql As String Try cnt.Open() tra = cnt.BeginTransaction() 'Setting Primary key to Null cause an error sSql = "UPDATE test_ado SET cod=Null WHERE cod ='00004'" Dim cmd As New Odbc.OdbcCommand(sSql, cnt) cmd.CommandText = sSql cmd.Transaction = tra cmd.ExecuteNonQuery() Catch ex As Exception MsgBox(ex.Message) MsgBox(cnt.State.ToString) End Try ---------------------------------------------------------------------- Comment By: Hiroshi Inoue (hinoue) Date: 2006-03-09 00:53 Message: Unfortunateky I don't know when the official libpq version will implement the functionalities which the REL_07_03_ENHANCED already has. ---------------------------------------------------------------------- Comment By: Lorenzo Marcone (marcone) Date: 2006-03-08 09:28 Message: REL-07_03_ENHANCED works correctly. I have not properly understood whether the functions of this version will be present in the official release or if they belong to two different projects ---------------------------------------------------------------------- Comment By: Hiroshi Inoue (hinoue) Date: 2006-03-01 23:47 Message: REL-07_03_ENHANCED version has an option to avoid the impicit rollback. Please try it. ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000563&group_id=1000125