Fujii Masao <masao.fu...@oss.nttdata.com> writes: > On 2020/04/09 16:11, Kyotaro Horiguchi wrote: >> At Wed, 08 Apr 2020 16:35:46 -0400, Tom Lane <t...@sss.pgh.pa.us> wrote in >>> Why is this getting grafted onto BEGIN/START TRANSACTION in the >>> first place?
>> The rationale for not being a fmgr function is stated in the following >> comments. [...] > This issue happens because the function is executed after BEGIN? If yes, > what about executing the function (i.e., as separate transaction) before > BEGIN? > If so, the snapshot taken in the function doesn't affect the subsequent > transaction whatever its isolation level is. I wonder whether making it a procedure, rather than a plain function, would help any. regards, tom lane