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

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_indexes doesn't show indexes for partitioned tables - bug or intended?
Date: 2019-04-10 16:20:59
Message-ID: d94e406f-a208-a1ff-9204-c025b20e700d@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 partitions however 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2019-04-10 18:12:13 Re: stale WAL files?
Previous Message Alvaro Herrera 2019-04-10 16:04:06 Re: pg_indexes doesn't show indexes for partitioned tables - bug or intended?