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
