Hi Tom,
Thank you, we have that same scenario.
Regards
Gerrit
On Wed, 13 Nov 2019, 20:57 Tom Lane, <tgl@xxxxxxxxxxxxx> wrote:
Gerrit Fouche <gerrit.fouche@xxxxxxxxx> writes:
> This is the second time I get this error since Postgresql 12 was officially
> released. My version:
> PostgreSQL 12.0 (Ubuntu 12.0-2.pgdg18.04+1) on x86_64-pc-linux-gnu,
> compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit
Given that this failed in an UPDATE, I suspect it's a known problem:
if you have a BEFORE UPDATE row-level trigger, and a concurrent update
on the same row happens, 12.0 can dump core due to a slot memory
management mistake. There's a fix in 12.1, due out tomorrow.
regards, tom lane