pg_dump: Fix inherited flag in extended stats from pre-v15 servers Servers older than v15 have no stxdinherit in pg_statistic_ext_data, so pg_dump hardcoded it to false. However, these versions build inherited extended stats on partitioned tables since 20b9fa308eb. Once restored as non-inherited, the data was ignored by the planner. pg_upgrade from v10~v14 was impacted by this issue.
For servers in this range, the inherited flag is now guessed from the relkind of the relation: true for partitioned tables and false otherwise, matching with what ANALYZE did before 269b532aef5 (introduction of pg_statistic_ext_data.stxdinherit). Oversight in c32fb29e979d. Author: Artem Gavrilov <[email protected]> Reviewed-by: Corey Huinker <[email protected]> Reviewed-by: Michael Paquier <[email protected]> Discussion: https://postgr.es/m/CAFPkQKxoB=kbdvshxhvprv5j2oobp5x5ea2yl9h0d3htjux...@mail.gmail.com Backpatch-through: 19 Branch ------ REL_19_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/cec8cb198ad3233c0b378edad202b111359b0793 Modified Files -------------- src/bin/pg_dump/pg_dump.c | 17 ++++++++++++++--- 1 file changed, 14 insertions(+), 3 deletions(-)
