Subject: Re: BUG #16976: server crash when deleting via a trigger on a foreign
 table
To: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-bugs@lists.postgresql.org,
 PG Bug reporting form <noreply@postgresql.org>
References: <16976-abe0cb88252bc02e@postgresql.org>
 <756273.1619012414@sss.pgh.pa.us>
From: Herwig Goemans <herwig.goemans@gmail.com>
Message-ID: <45a2dc04-54a8-690d-a959-47e791a7f686@gmail.com>
Date: Wed, 21 Apr 2021 16:08:16 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.7.1
MIME-Version: 1.0
In-Reply-To: <756273.1619012414@sss.pgh.pa.us>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: nl-BE
Archived-At: 
 <https://www.postgresql.org/message-id/45a2dc04-54a8-690d-a959-47e791a7f686%40gmail.com>
Precedence: bulk

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