Search Postgresql Archives

Re: Error XX000 After pg11 upgrade

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi

Thanks for all the help, and a couple of offlist suggestions.

We have fixed the problem by copying all of the data (160GB) to a partitioned table, replacing the trigger with table column defaults for timestamp and sequence values.

As a result, all is working ok.

Thank you, once again

Simon

On Fri, 16 Aug 2019 at 01:28, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Simon Windsor <simon.windsor@xxxxxxxxxxxxxxx> 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


--
Simon

Simon Windsor
Eml: simon.windsor@xxxxxxxxxxxxxxxx
Tel: 01454 617689
Mob: 07960 321599

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux