>> 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. Mark
_______________________________________________ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer