Re: Avoid deadlocks on alter table

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?
Thanks.

2016-07-06 9:43 GMT+02:00 Christian Castelli <voodoo81people(at)gmail(dot)com>:

>
> 2016-07-05 16:01 GMT+02:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:
>
>>
>> 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(at)sss(dot)pgh(dot)pa(dot)us>:
>
>> 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 Castelliskype: christrack*
>

--

*Christian Castelliskype: christrack*