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(-)

Reply via email to