Hi,
$subject came up in [1].
Should relhassubclass be set/reset for partitioned indexes?
The only use case being sought here is to use find_inheritance_children()
for getting an index's partitions, but it uses relhassublcass test to
short-circuit scanning pg_inherits. That means it cannot be used to get
an index's children, because relhassublcass is never set for indexes.
Michael suggested on the linked thread to get rid of relhassubclass
altogether, like we did for relhaspkey recently, but I'm not sure whether
it would be a good idea right yet.
Thoughts?
Thanks,
Amit
[1]
https://www.postgresql.org/message-id/3acdcbf4-6a62-fb83-3bfd-5f275602ca7d%40lab.ntt.co.jp