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_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/cb157339c474333ef0e40b3c524a486274cf719e

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

FAQ