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?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?
2016-07-06 9:43 GMT+02:00 Christian Castelli <voodoo81people@xxxxxxxxx>:
2016-07-05 16:01 GMT+02:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
Does the server log have the details, per above?No, it copies just the schema from base_template with a CREATE TABLE x AS base_template.x WITH NO DATA.2016-07-05 17:24 GMT+02:00 Tom Lane <tgl@xxxxxxxxxxxxx>:I think it'd likely be enough to add the FKs one at a time, rather
than all in one transaction.
Ok I'll try first to do this.Thanks.
--Christian Castelli
skype: christrack
--
Christian Castelli
skype: christrack
skype: christrack
