Catalog views failed to show partitioned table information.
Suraj Kharage <suraj.kharage@enterprisedb.com>
From: Suraj Kharage <suraj.kharage@enterprisedb.com>
To: pgsql-hackers@postgresql.org
Date: 2018-12-14T11:51:49Z
Lists: pgsql-hackers
Attachments
- pg_indexes_fix_for_partition_index.patch (application/octet-stream) patch
Hi, 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. 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? Regards, Suraj
Commits
-
Include partitioned indexes to system view pg_indexes
- f94cec64476f 12.0 landed