Re: BUG #17035: assert after commit

From: RekGRpth <rekgrpth(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17035: assert after commit
Date: 2021-05-27 03:51:09
Message-ID: CAPgh2mJ7-4K8j2NVCDb_uUYEF67Nh9xqXyNURnD9TYQWMCAAjA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

чт, 27 мая 2021 г. в 08:22, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>
> RekGRpth <rekgrpth(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2021-05-27 06:48:37 Re: BUG #17034: Creating aggregate function based on array_append now results in "function does not exist" error
Previous Message Tom Lane 2021-05-27 03:22:42 Re: BUG #17035: assert after commit