Alvaro Herrera <alvhe...@2ndquadrant.com> writes: > Now that I re-read this complaint once again, I wonder if a mismatching > column order in partitions isn't a thing we ought to preserve anyhow. > Robert, Amit -- is it by design that pg_dump loses the original column > order for partitions, when not in binary-upgrade mode?
I haven't looked at the partitioning code, but I am quite sure that that's always happened for old-style inheritance children, and I imagine pg_dump is just duplicating that old behavior. Wasn't there already a patch on the table to change this, though, by removing the code path that uses inheritance rather than the binary-upgrade-like solution? regards, tom lane