On 2019-Apr-11, David Rowley wrote: > On Thu, 11 Apr 2019 at 00:39, Thomas Kellerer <spam_ea...@gmx.net> wrote: > > > > 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.
(You can, of course, adjust the view definition yourself.) -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
