Re: Dependencies for partitioned indexes are still a mess - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Dependencies for partitioned indexes are still a mess
Date
Msg-id 324385.1597271356@sss.pgh.pa.us
Whole thread Raw
In response to Dependencies for partitioned indexes are still a mess  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> I've attached the diff between first.sql and second.sql. Here's the
> highlights:

As I recall, the differences in b_star etc are expected, because
pg_dump reorders that table's columns to match its inheritance parent,
which they don't to start with because of ALTER TABLE operations.

I'm pretty sure we set it up that way deliberately ages ago, because
pg_dump used to have bugs when contending with such cases.  Not sure
about a good way to mechanize recognizing that these diffs are
expected.

Dunno about test_type_diff2, but it might be a newer instance of
the same thing.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Parallel query hangs after a smart shutdown is issued
Next
From: Andres Freund
Date:
Subject: run pgindent on a regular basis / scripted manner