Re: Avoid deadlocks on alter table

[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