search

GispoCoding / qaava-qgis-plugin

QGIS 3 Plugin for Qaava https://github.com/GispoCoding/qaava
GNU General Public License v2.0
3 stars 0 forks source link

Cascade delete #55

Closed SannaJokela closed 3 years ago

SannaJokela commented 3 years ago

Foreign key constraint error for many-to-many relations when trying to delete features. Throws an error like:

PostGIS error while deleting features: ERROR: update or delete on table "maankayttoalue" violates foreign key constraint "maankayttoalue_fk" on table "many_maankayttoalue_has_many_kaavamaarays" DETAIL: Key (uuid)=(ec841bd0-f275-4431-9158-e081d5884ece) is still referenced from table "many_maankayttoalue_has_many_kaavamaarays".

This affects both asemakaava and yleiskaava QGIS projects and all spatial layers and all relations.

Joonalai commented 3 years ago

@SannaJokela this should be issue for qaava project, not qaava-qgis-project I think.

SannaJokela commented 3 years ago

@Joonalai ok. Sorry :)