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

[ psqlodbc-Bugs-1000457 ] Autocommit and Cancel

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000457 ] Autocommit and Cancel
Date: 2005-12-06 10:14:34
Message-ID: 20051206101434.3678D1125043@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Bugs item #1000457, was opened at 2005-11-30 15: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: Accepted
Priority: 3
Submitted By: Nobody (None)
>Assigned to: Ludek Finstrle (luf)
Summary: Autocommit and Cancel

Initial Comment:
Our application in one thread issued long time SELECT, another thread cancelled this statement. After that first thread tried to issue next SELECT and got error message because current transaction is aborted with error. As I saw in postgresql server 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.

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

>Comment By: Ludek Finstrle (luf)
Date: 2005-12-06 11:14

Message:
There is problem that exec is blocking and cancel is for non-blocking operations.
I'll fix it as soon as possible.

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

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

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2005-12-06 14:28:11
Subject: Re: [ODBC] BLOB handling compatibility with PostgreSQL > 7.4
Previous:From: noreplyDate: 2005-12-06 10:12:19
Subject: [ psqlodbc-Bugs-1000460 ] UseServerSidePrepare still broken

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