On 08/06/2018 03:13 PM, Tom Lane wrote:
Jacob Champion <pchamp...@pivotal.io> writes:
We recently ran into an issue in pg_dump that caused the initial
sort-by-name pass to return incorrect results. It doesn't seem to
affect overall correctness, since the later toposort pass takes care
of dependencies, but it does occasionally cause a spurious diff in
dump output before and after a pg_upgrade run.
Do you mean "incorrect results", or just "unstable results"?
If the former, what's incorrect about it?
I'd also like to see a test case.
We should perhaps have a more representative set of data for the upgrade
testing, both same version and cross-version, which judge success by
comparing pre and post dumps, but I don't recall ever seeing this.
cheers
andrew
--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
