[PATCH] pg_dump: Do not dump statistics for excluded tables

Поиск
Список
Период
Сортировка
От Rian McGuire
Тема [PATCH] pg_dump: Do not dump statistics for excluded tables
Дата
Msg-id 7075d3aa-3f05-44a5-b68f-47dc6a8a0550@buildkite.com
обсуждение исходный текст
Ответы Re: [PATCH] pg_dump: Do not dump statistics for excluded tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi hackers,

I've attached a patch against master that addresses a small bug in pg_dump.

Previously, pg_dump would include CREATE STATISTICS statements for
tables that were excluded from the dump, causing reload to fail if any
excluded tables had extended statistics.

The patch skips the creation of the StatsExtInfo if the associated
table does not have the DUMP_COMPONENT_DEFINITION flag set. This is
similar to how getPublicationTables behaves if a table is excluded.

I've covered this with a regression test by altering one of the CREATE
STATISTICS examples to work with the existing 'exclude_test_table'
run. Without the fix, that causes the test to fail with:
# Failed test 'exclude_test_table: should not dump CREATE STATISTICS
extended_stats_no_options'
# at t/002_pg_dump.pl line 4934.

Regards,
Rian
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrei Lepikhov
Дата:
Сообщение: Re: POC: GROUP BY optimization
Следующее
От: Tom Lane
Дата:
Сообщение: Re: POC: GROUP BY optimization