Re: backend crash on DELETE, reproducible locally - Mailing list pgsql-general

From Tom Lane
Subject Re: backend crash on DELETE, reproducible locally
Date
Msg-id 18072.1541087036@sss.pgh.pa.us
Whole thread Raw
In response to Re: backend crash on DELETE, reproducible locally  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: backend crash on DELETE, reproducible locally
List pgsql-general
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> Ah, now this is interesting.  Can you please supply the definition of
> the table?  I'm wondering if there is a partitioned table with an FK to
> this one.  I'm not quite seeing how come 'tup' is NULL there.

Yeah, apparently we've passed a null OLD tuple to an RI_FKey_cascade_del
trigger, which surely shouldn't happen.  It'd be interesting to look at
the set of triggers on this table.  I don't entirely trust psql's \d
to show us reality if there's something screwed up about the triggers,
so in addition to \d output, could we see

select * from pg_trigger where tgrelid  = 'ref.auto_hint'::regclass;

            regards, tom lane


pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: backend crash on DELETE, reproducible locally
Next
From: Karsten Hilbert
Date:
Subject: Re: backend crash on DELETE, reproducible locally