Re: BUG #16976: server crash when deleting via a trigger on a foreign table

From: Herwig Goemans <herwig(dot)goemans(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org, PG Bug reporting form <noreply(at)postgresql(dot)org>
Subject: Re: BUG #16976: server crash when deleting via a trigger on a foreign table
Date: 2021-04-21 14:08:16
Message-ID: 45a2dc04-54a8-690d-a959-47e791a7f686@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I was in the process of reproducing the problem and following the
guidelines to produce the stack trace... but now it works.

I asked my colleagues if they changed anything and will let you know.

Thanks for the quick response, and I will keep you posted if I have any
news.

Kind regards,

Herwig

On 21/04/2021 15:40, Tom Lane wrote:
>> I have experienced a server crash when deleting from a table that ahs a
>> before trigger on it. The before trigger calls a function that deletes from
>> a foreign (informix) table.
> Hm, can you get a stack trace from that?
>
> https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
>
> It seems fairly likely that the bug is in whatever FDW you're using
> rather than in core Postgres. A stack trace would help to
> confirm or refute that.
>
> regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-04-21 19:10:09 Re: posgres 12 bug (partitioned table)
Previous Message Tom Lane 2021-04-21 13:40:14 Re: BUG #16976: server crash when deleting via a trigger on a foreign table