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?
Re: pg_indexes doesn't show indexes for partitioned tables - bug orintended? |
Список | 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 по дате отправления: