claeis / ili2db

interlis import/export to relational databases
30 stars 30 forks source link

--deleteData does not work with --createFk #548

Closed edigonzales closed 3 weeks ago

edigonzales commented 2 months ago

Falls das Schema mit --createFk erstellt wurde, funktioniert --deleteData nicht:

Info: Basket SO_AGI_Datahub_Config_20240403.Core(oid SO_AGI_Datahub_Config_20240403.Core)...
Info: object count 22
Error: commit failed
Error:   ERROR: update or delete on table "t_ili2db_basket" violates foreign key constraint "t_ili2db_import_basket_basket_fkey" on table "t_ili2db_import_basket"
  Detail: Key (t_id)=(3) is still referenced from table "t_ili2db_import_basket".
...import failed