Re: Error XX000 After pg11 upgrade - Mailing list pgsql-general

From Tom Lane
Subject Re: Error XX000 After pg11 upgrade
Date
Msg-id 8458.1565915286@sss.pgh.pa.us
Whole thread Raw
In response to Re: Error XX000 After pg11 upgrade  (Simon Windsor <simon.windsor@cornfield.me.uk>)
Responses Re: Error XX000 After pg11 upgrade
List pgsql-general
Simon Windsor <simon.windsor@cornfield.me.uk> writes:
> Since then, large bulk inserts of configuration changes are failing with 
> this Error, but adhoc and small changes are working ok.

Might it be that things work as long as the trigger is only tasked with
redirecting to the same child table (or limited set of child tables)
within a particular insertion command?

I'm wondering if this could be related to bug #15913 --- which I just
fixed today, so maybe I just have it on the brain too much.  The
manifestation doesn't look quite the same, but given the way your
trigger is written, something about NEW.* changing type from one
call to the next might have something to do with it.

I also wonder how often you create/delete child tables.

            regards, tom lane



pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Error XX000 After pg11 upgrade
Next
From: Charles Clavadetscher
Date:
Subject: Re: Variable constants ?