Hi,
> Could you write a patch? It would be better to have tests with
> multiple levels, at least, with a partitioned table being a leaf of
> another partitioned table. I am sure you get the picture, the point
> being to recurse across multiple levels.
Here is the patch with tests. It adds a test for this case using
multi-level partitions and ensures that the parent indexes are
validated once a child index is set to valid. Also, I added the
negative case where only one child index is validated to ensure
that the parent indexes remain invalid.
--
Sami Imseih
Amazon Web Services (AWS)