Hi Justin, > Maybe I'm wrong, but I don't think there's any known difficulty - just that> > nobody did it yet. You should pay attention to what happens on error, but > hopefully you wouldn't need to add much code and can rely on existing code to > paths to handle that right.
yes, I am trying to learn the code of index definition. > I think you'd look at the commits and code implementing indexes on partitioned > tables and CREATE INDEX CONCURRENTLY. And maybe any following commits with > fixes. > You'd first loop around all children (recursively if there are partitions > which > are themselves partitioned) and create indexes concurrently. As we all know, CIC has three transactions. If we recursively in n partitioned tables, it will become 3N transactions. If an error occurs in these transactions, we have too many things to deal... If an error occurs when an index is created in one of the partitions, what should we do with our new index? Thank you very much, Regards, Adger
