pgsql: pg_dump: Fix inherited flag in extended stats from pre-v15 serve
pgsql: pg_dump: Fix inherited flag in extended stats from pre-v15 serve
От:
Michael Paquier <michael@paquier.xyz>
Дата:
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 Reviewed-by: Corey Huinker Reviewed-by: Michael Paquier Discussion: https://postgr.es/m/CAFPkQKxoB=kBdVsHXHvprV5j2OOBP5x5ea2yL9h0d3HtjuX+Sg@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(-)