[Qgis-developer] PostGIS edition and foreign key

[Rémi Cura]

How do you merge exactly?

You could use PostGIS trick, like droping the foreign key constraint, and
trusting QGIS, but it would be a poor idea.

Another option would be to create triggers to clean the merging done by
qgis, so no foreign key constraint is violated, but it would depend on what
is this merge exactly.

Are you talking about the
vector/geoprocessing tools/Dissolve ?

Cheers,
Rémi-C

2015-03-03 11:14 GMT+01:00 Thibaut Gheysen <gheysen.t at gmail.com>:

> Hi,
>
> I would like to have your opinion in order to simplify as much as possible
> our current workflow.
>
> We have a table parcel and a table operation. The table operation include
> a foreign key to the table parcel. We have 2 parcels (A and B) but only
> parcel A has operations link on it. I would like to merge the 2 parcels by
> keeping the attributes of the parcel A. The merge is doing properly but
> impossible to save the edit (Provider errors: PostGIS error while deleting
> feature: ERROR: update or delete table "parcel" violates foreign key
> constraint"fk_parcel" on table "operation"). I guess this is due to the
> fact the Qgis first delete the 2 parcels (A and B) before creating a new
> one (merged one).
> This behaviour oblige us to export the table parcel into a shapefile and
> make the modifications on it. Once done, we import the shapefile into
> PostGIS and update the parcel geometry base on it.
>
> Is there any chance to find an easier workflow, without developing a
> plug-in ?
>
> Thank for your help.
>
> Best regards,
> Thibaut.
>
>
>
>
>
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20150303/e6ea9e8a/attachment-0001.html>