Horton

Re: pg_upgrade failed with ERROR: null relpartbound for relation 18159 error.

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2018-10-07T07:59:56Z
Lists: pgsql-hackers 
On Sat, Oct 06, 2018 at 10:15:32PM -0300, Alvaro Herrera wrote:
> Pushed to 11 and master.  I'm not convinced that it's a good idea to
> mess with 10 at this point -- the partitioning code is rather completely
> different already ...

While I definitely agree with you to not mess up with this portion of
the partitioning code for REL_10_STABLE, I think that we have a good set
of arguments to get the regression test into this branch.  This
particular case has been broken while developing v11, hence it would be
nice to get the insurance that any future bug fix applying to
REL_10_STABLE does not break it again.
--
Michael

Commits

  1. Add regression test for ATTACH PARTITION

  2. Fix catalog insertion order for ATTACH PARTITION

  3. Simplify partitioned table creation vs. relcache