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. -- Michael
signature.asc
Description: PGP signature