Re: Catalog views failed to show partitioned table information.

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Suraj Kharage <suraj(dot)kharage(at)enterprisedb(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Catalog views failed to show partitioned table information.
Date: 2018-12-14 23:00:32
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Fri, Dec 14, 2018 at 05:21:49PM +0530, Suraj Kharage wrote:
> There are some catalog views which do not show the partitioned table and
> its index entry.
> One of them is "pg_indexes" which failed to show the partitioned index.
> Attached the patch which fixes the same.

I tend to agree with your comment here. pg_tables lists partitioned
tables, but pg_indexes is forgotting about partitioned indexes. So this
is a good thing to add.

> Other views such as pg_stat*,pg_statio_* has the same problem for
> partitioned tables and indexes.
> Since the partitioned tables and its indexes considered as a dummy, they do
> not have any significance in stat tables,
> can we still consider adding relkind=p in these pg_stat_* views? Thoughts?

I am less sure about that as partitioned relations do not have a
physical presence.

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2018-12-14 23:03:48 Re: Variable-length FunctionCallInfoData
Previous Message Tom Lane 2018-12-14 22:50:03 Re: BUG #15548: Unaccent does not remove combining diacritical characters