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

Re: ODBC & Transactions?

From: "Mike Miller" <mmiller(at)pooka(dot)otago(dot)ac(dot)nz>
To: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC & Transactions?
Date: 2001-11-08 01:50:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
> CommitTransactionCommand doesn't necessarily mean COMMIT.
> You have to use BeginTrans to turn of the autocommit mode
> but it doesn't seem the cause of your case(It works well
> here). Judging from the psqlodbc.log file you posted,
> "rollback work" is issued by the differenct connection
> from the one which issued "begin work" and "update ...".
> Hmm are you using connection pooling ?

I don't know if I am using connection pooling or not.  Is it client side or
server side?
Where do I find out? I am using Visual Basic 6 with ADO and psqlodbc.

conn=86609100, query='BEGIN WORK'
conn=86609100, query='update Practical set Descr ...
conn=86628184, query='ROLLBACK WORK'
NOTICE from backend during send_query: 'NOTICE:  ROLLBACK: no transaction in


conn=86609100, query='BEGIN WORK'
conn=86628184, query='update Practical set Descri ...
conn=86609100, query='ROLLBACK WORK'

I see what you mean.  From some tests it *seems* to randomly pick a
connection to use; which would explain why it worked sometimes (and really
confused me :-)


In response to


pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-11-08 02:12:20
Subject: Re: ODBC & Transactions?
Previous:From: Hiroshi InoueDate: 2001-11-08 00:58:36
Subject: Re: ODBC and Native error codes

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