pgsql: Fix failure when creating cloned indexes for a partition

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема pgsql: Fix failure when creating cloned indexes for a partition
Дата
Msg-id E1iQloA-0003vc-Df@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix failure when creating cloned indexes for a partition

When using CREATE TABLE for a new partition, the partitioned indexes of
the parent are created automatically in a fashion similar to LIKE
INDEXES.  The new partition and its parent use a mapping for attribute
numbers for this operation, and while the mapping was correctly built,
its length was defined as the number of attributes of the newly-created
child, and not the parent.  If the parent includes dropped columns, this
could cause failures.

This is wrong since 8b08f7d which has introduced the concept of
partitioned indexes, so backpatch down to 11.

Reported-by: Wyatt Alt
Author: Michael Paquier
Reviewed-by: Amit Langote
Discussion: https://postgr.es/m/CAGem3qCcRmhbs4jYMkenYNfP2kEusDXvTfw-q+eOhM0zTceG-g@mail.gmail.com
Backpatch-through: 11

Branch
------
REL_11_STABLE

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

Modified Files
--------------
src/backend/commands/tablecmds.c           |  2 +-
src/test/regress/expected/create_table.out | 49 ++++++++++++++++++++++++++++++
src/test/regress/sql/create_table.sql      | 23 ++++++++++++++
3 files changed, 73 insertions(+), 1 deletion(-)


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: pgsql: Add some assertions in syncrep.c
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Validate ispell dictionaries more carefully.