Re: Two phase commit in ECPG

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: Michael Meskes <meskes(at)postgresql(dot)org>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Two phase commit in ECPG
Date: 2017-03-07 10:55:58
Message-ID: CAD21AoDta1-HQ5KAF6K=kTZz5Lxr-D2dHYixqwc=ZYp5AMLb3Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Sat, Mar 4, 2017 at 4:11 AM, Michael Meskes <meskes(at)postgresql(dot)org> wrote:
> Dear Sawada-san,
>
>> This cause is that the "begin transaction" is issued automatically
>> before executing COMMIT PREPARED if we're not in auto commit. The
>> Commit 816b008eaf1a1ff1069f3bafff363a9a8bf04a21 fixed bug of
>> incorrect
>> status calculation but at the same time it became the cause of this
>> behavior.
>> Is this a bug?
>
> I'd say so, yes.
>
> As soon as I find time I'll get to it including back porting your
> patch.

Thanks

Previous 002 patch lacked to add describing PREPARE TRANSACTION.
Attached updated 002 patch.

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Attachment Content-Type Size
002_ecpg_commit_rollback_prepared_doc_v2.patch application/octet-stream 1.2 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message spesternikov 2017-03-07 12:33:47 BUG #14580: pgbench bug
Previous Message Rader, David 2017-03-06 14:45:47 Re: [BUGS] Seems bug in postgres_fdw?

Browse pgsql-hackers by date

  From Date Subject
Next Message Giuseppe Broccolo 2017-03-07 10:58:42 Re: dump a comment of a TSDictionary
Previous Message Amit Langote 2017-03-07 10:54:48 Re: exposing wait events for non-backends (was: Tracking wait event for latches)