[ psqlodbc-Bugs-1000457 ] Autocommit and Cancel - Mailing list pgsql-odbc

From
Subject [ psqlodbc-Bugs-1000457 ] Autocommit and Cancel
Date
Msg-id 20051130143642.5D8051125054@pgfoundry.org
Whole thread Raw
List pgsql-odbc
Bugs item #1000457, was opened at 2005-11-30 14:36
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000457&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Autocommit and Cancel

Initial Comment:
Our application in one thread issued long time SELECT, another thread cancelled this statement. After that first thread
triedto issue next SELECT and got error message because current transaction is aborted with error. As I saw in
postgresqlserver logs there was no ROLLBACK statement issued by driver after cancellation. 

We're using autocommit mode. Mylog file is attached.
Server version is 7.4.6, psqlodbc version is 08.01.0101.
Also, we use unixODBC 2.2.8 with option "Threading=0" in odbcinst.ini.

Thank you.

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000457&group_id=1000125

pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1000455 ] Autocommit, Cancel and DateStyle
Next
From:
Date:
Subject: [ psqlodbc-Bugs-1000460 ] UseServerSidePrepare still broken