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

Re: Rollback transaction doesn't work

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: KJ <kjatwork(at)gmx(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Rollback transaction doesn't work
Date: 2007-04-26 21:40:04
Message-ID: 46311C34.1080206@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
I wrote:
> KJ wrote:
>> Hi all,
>>
>> it seems as if ODBC provider doesn't work correctly in conjunction with MSDTC.
>> Transaction are handled correctly using pgadmin or an ODBC based client (e.g. WinSQL).
>>
>> When running statements from MS SQL Server then in case of a rollback transaction a COMMIT is being forwarded to postgres (see log file below).
>>
>> Any help is welcome.
> 
> Could you send me the Mylog output ?

Could you try first
  begin distributed transaction
instead of
  begin transaction
?

regards,
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Zahid KhanDate: 2007-04-30 15:22:53
Subject: psqlodbc communication over protocol
Previous:From: Hiroshi InoueDate: 2007-04-26 18:52:55
Subject: Re: Rollback transaction doesn't work

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