pgsql: Ignore invalid indexes in pg_dump.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Ignore invalid indexes in pg_dump.
Дата
Msg-id E1UKbes-000182-GO@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Ignore invalid indexes in pg_dump.

Dumping invalid indexes can cause problems at restore time, for example
if the reason the index creation failed was because it tried to enforce
a uniqueness condition not satisfied by the table's data.  Also, if the
index creation is in fact still in progress, it seems reasonable to
consider it to be an uncommitted DDL change, which pg_dump wouldn't be
expected to dump anyway.

Back-patch to all active versions, and teach them to ignore invalid
indexes in servers back to 8.2, where the concept was introduced.

Michael Paquier

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/683abc73dff549e94555d4020dae8d02f32ed78b

Modified Files
--------------
src/bin/pg_dump/pg_dump.c |    2 ++
1 files changed, 2 insertions(+), 0 deletions(-)


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Ignore invalid indexes in pg_dump.
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Ignore invalid indexes in pg_dump.