pgsql: Fix partitioned index attachment

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема pgsql: Fix partitioned index attachment
Дата
Msg-id E1hJgDO-00037n-DA@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix partitioned index attachment

When an existing index in a partition is attached to a new index on
its parent, we forgot to set the "relispartition" flag correctly, which
meant that it was not possible to find the index in various operations,
such as adding a foreign key constraint that references that partitioned
table.  One of four places that was assigning the parent index was
forgetting to do that, so fix by shifting responsibility of updating the
flag to the routine that changes the parent.

Author: Amit Langote, Álvaro Herrera
Reported-by: Hubert "depesz" Lubaczewski
Discussion: https://postgr.es/m/CA+HiwqHMsRtRYRWYTWavKJ8x14AFsv7bmAV46mYwnfD3vy8goQ@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/05b38c7e63d1c8bca8c07ab4c8b194eed3c50ec7

Modified Files
--------------
src/backend/commands/indexcmds.c          | 24 ++++++++++++++++++++
src/backend/commands/tablecmds.c          | 37 -------------------------------
src/test/regress/expected/foreign_key.out | 12 ++++++++++
src/test/regress/sql/foreign_key.sql      | 10 +++++++++
4 files changed, 46 insertions(+), 37 deletions(-)


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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: pgsql: Fix file path in comment.
Следующее
От: Alvaro Herrera
Дата:
Сообщение: pgsql: Fix partitioned index attachment