Re: Rollback transaction doesn't work

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: Rollback transaction doesn't work
Дата
Msg-id 46311C34.1080206@tpf.co.jp
обсуждение исходный текст
Ответ на Re: Rollback transaction doesn't work  (Hiroshi Inoue <inoue@tpf.co.jp>)
Список 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

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Rollback transaction doesn't work
Следующее
От: Zahid Khan
Дата:
Сообщение: psqlodbc communication over protocol