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

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: pg_indexes doesn't show indexes for partitioned tables - bug or intended?
Дата
Msg-id CAKJS1f8Jp11xrPu35rHMr7Q8GTFwYEKT=YCkJQo7bP0=F8iCUg@mail.gmail.com
обсуждение исходный текст
Ответ на pg_indexes doesn't show indexes for partitioned tables - bug orintended?  (Thomas Kellerer <spam_eater@gmx.net>)
Ответы Re: pg_indexes doesn't show indexes for partitioned tables - bug orintended?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: pg_indexes doesn't show indexes for partitioned tables - bug orintended?  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
On Thu, 11 Apr 2019 at 00:39, Thomas Kellerer <spam_eater@gmx.net> wrote:
>
> 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.

[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=f94cec64476f2752e91b10d7928a2fcd105e9fc3

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Sherrylyn Branchaw
Дата:
Сообщение: Re: Does pg_stat_get_live_tuples() matter?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_indexes doesn't show indexes for partitioned tables - bug orintended?