Migration importing data in pipe_point and subclasses about district_heating HOT 4 OPEN

@sjib
ALTER TABLE tdh_od.pipe_point_normal ALTER CONSTRAINT oorel_od_pipe_point_normal_pipe_point DEFERRABLE INITIALLY DEFERRED

I followed your instructions, but did have any success 👎 with fme (also run set constraints all deferred (sql to run before write)
Bulk copy failed on table 'tdh_od.trench_line' using delimiter ':'. Error was 'ERROR: insert or update on table "trench_line" violates foreign key constraint "rel_trench_line_trench"
DETAIL: Key (fk_trench)=(1) is not present in table "trench".

from district_heating.

@jpdupuy This is not the problem of pipe_point subclasses anymore (?) but of trench_line.fk_trench
You have to set DEFERRABLE INITIALLY DEFERRED for that relation also.
If this is a new error then the first step was a success.

from district_heating.

If this is successful I can add DEFERRABLE INITIALLY DEFERRED to all relations as with tww

from district_heating.

@sjib Yes, it was successful, thanks

from district_heating.