pgsql: pg_dump: Include column statistics for index-backed constraints
pgsql: pg_dump: Include column statistics for index-backed constraints
От:
Michael Paquier <michael@paquier.xyz>
Дата:
pg_dump: Include column statistics for index-backed constraints dumpIndex() emits ALTER INDEX .. SET STATISTICS for per-column statistics targets, but dumpConstraint() never did. Targets set on the expression columns of an exclusion constraint's index were silently lost on dump/restore and pg_upgrade. The same code can be used in the index and constraint dump code to generate these ALTER INDEX commands. The logic has been refactored so that both share a new subroutine in charge of generating all these custom SET STATISTICS, if any. Oversight in e4fca461ab6f. Author: Zsolt Parragi Reviewed-by: Chao Li Reviewed-by: Andrew Krylosov Discussion: https://postgr.es/m/CAN4CZFMd9riOuV5LkM+uV=uF-HYp49C8Fh22xWyMxptGLBCZ3A@mail.gmail.com Backpatch-through: 14 Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/37bbf5bba09c4244d74f152557e69f73f2b6690e Modified Files -------------- src/bin/pg_dump/pg_dump.c | 86 ++++++++++++++++++++++------------------ src/bin/pg_dump/t/002_pg_dump.pl | 25 ++++++++++++ 2 files changed, 72 insertions(+), 39 deletions(-)