Hi, by splitting FK contraints, once failed on fk_plan creation while the second time failed on rebuilding public views. I've done a PLPGSQL function that cycles through all schemata and builds views with lots of UNION to join the result. Obviously there are other processes which use these global views so how can I update these global views without interfering with other processes?
Should I avoid using these views and build by myself the queries with code? Is there another better approach for finding results with this type of architecture?