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)
v1-0001-Allow-ALTER-INDEX-ATTACH-PARTITION-to-validate-th.patch
Description: Binary data
