Re: pg_indexes doesn't show indexes for partitioned tables - bug orintended?

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: pg_indexes doesn't show indexes for partitioned tables - bug orintended?
Дата
Msg-id d94e406f-a208-a1ff-9204-c025b20e700d@gmx.net
обсуждение исходный текст
Ответ на Re: pg_indexes doesn't show indexes for partitioned tables - bug or intended?  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: pg_indexes doesn't show indexes for partitioned tables - bug or intended?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
David Rowley schrieb am 10.04.2019 um 17:57:
>> In Postgres 11.2, indexes defined on partitioned tables do not show up in pg_indexes (the actual indexes for the
partitionshowever do show up). 
>
>> Is leaving out the indexes defined on the partitioned table intended or a bug?
>
> Overlooked for PG11. You'll see them in PG12 per [1]. It's not really
> possible to backpatch a fix for that since these views are created
> during initdb.

Thanks.

I don't undertand though why it's not back patched - at least that would fix the bug for new installations

Thomas



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_indexes doesn't show indexes for partitioned tables - bug orintended?
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: stale WAL files?