Re: pg_indexes doesn't show indexes for partitioned tables - bug orintended? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: pg_indexes doesn't show indexes for partitioned tables - bug orintended?
Date
Msg-id d94e406f-a208-a1ff-9204-c025b20e700d@gmx.net
Whole thread Raw
In response to Re: pg_indexes doesn't show indexes for partitioned tables - bug or intended?  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: pg_indexes doesn't show indexes for partitioned tables - bug or intended?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_indexes doesn't show indexes for partitioned tables - bug orintended?
Next
From: Rob Sargent
Date:
Subject: Re: stale WAL files?