Postgres Pro
Downloads
Home   >   mailing lists

Catalog views failed to show partitioned table information. - Mailing list pgsql-hackers

From Suraj Kharage
Subject Catalog views failed to show partitioned table information.
Date
Msg-id CAF1DzPVrYo4XNTEnc=PqVp6aLJc7LFYpYR4rX=_5pV=wJ2KdZg@mail.gmail.com
Whole thread Raw
Responses Re: Catalog views failed to show partitioned table information.
List pgsql-hackers
Tree view
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
Attachment

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: explain plans with information about (modified) gucs
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] REINDEX CONCURRENTLY 2.0