[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: BUG #17035: assert after commit
From:       RekGRpth <rekgrpth () gmail ! com>
Date:       2021-05-27 3:51:09
Message-ID: CAPgh2mJ7-4K8j2NVCDb_uUYEF67Nh9xqXyNURnD9TYQWMCAAjA () mail ! gmail ! com
[Download RAW message or body]

Ok, thanks. I add PushActiveSnapshot(GetTransactionSnapshot()); after
SPI_start_transaction and PopActiveSnapshot(); before SPI_commit and
it works!
with bst regrds, Rek>pth

=D1=87=D1=82, 27 =D0=BC=D0=B0=D1=8F 2021 =D0=B3. =D0=B2 08:22, Tom Lane <tg=
l@sss.pgh.pa.us>:
>
> RekGRpth <rekgrpth@gmail.com> writes:
> > Ok, I see. But I use SPI_execute_plan in background worker and no
> > ActivePortal there
>
> Well, you need to provide a snapshot.  replication/worker.c
> might serve as an example.
>
>                         regards, tom lane


[prev in list] [next in list] [prev in thread] [next in thread]