Andres Freund <and...@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