[ psqlodbc-Bugs-1000563 ] Rollback in manual transaction - Mailing list pgsql-odbc

From
Subject [ psqlodbc-Bugs-1000563 ] Rollback in manual transaction
Date
Msg-id 20060318215611.0F14A1033834@pgfoundry.org
Whole thread Raw
List pgsql-odbc
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

pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1000567 ] Discrepant results versus other connections
Next
From:
Date:
Subject: [ psqlodbc-Bugs-1000564 ] Rollback in manual transaction