Hi Bernd Thanks for your comments
As a previous commenter wrote, Spatialite also uses a similar format to Geopackage being also based on SQLite.
So far in my testing of Spatialite I have found it to have neither issue. Spatialite converted from Geopackage creates another field called ogc_fid and ignores the fid field from the Geopackage. A test paste resulted in the ogc_fid values being automatically updated to new ones when the table is posted.
I dropped several columns in a table with 38,000 records and saw no data loss with Spatialite, either.
I still have to test with 2.18 and the newest master to see how they work with geopackage files before filing a bug report.
I guess a question is whether the server based implementation of Geopackage has these issues.
On 3/02/21 3:06 am, Bernd Vogelgesang wrote:
for 2. I found a "workaround": As far as I remember, copy/paste works, but when trying to save, you get this warning/error. In the attribute table, I pick the "fid" column, enter "$id" and perform "update all". After that the layer can be saved. A novice user will never come to that solution by itself, so this a real show stopper for gpkg.
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
