[QGIS-Developer] GeoPackages with constraint problems

Mark Johnson mj10777 at googlemail.com
Thu Aug 9 00:59:58 PDT 2018

>> Executing PRAGMA foreign_keys = ON
This is also done for Spatialite in the SpatialiteProvider, so this is not
a general GeoPackage issue.

The need to keep this on is important, since the TRIGGERS enforces the
'sanity' of the data (such as same srid and geometry-type rules).

Also the Database-Designer can add there own rules, make a general, semi
automatic  'repair' routines basically impossible.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20180809/131b3286/attachment.html>

More information about the QGIS-Developer mailing list