I agree too - I also dont like that we get an FID column when we import another table that already has an id column….all sorts of chaos ensues….
https://github.com/qgis/QGIS/issues/30697 Regards Tim > On 19 Mar 2020, at 17:00, René-Luc Dhont <[email protected]> wrote: > > I agree, so in my algorithms working with geopackage I always redefined FID > with > > options = QgsVectorFileWriter.SaveVectorOptions() > options.layerOptions = ['FID=id'] > > For me it is like a primary key in PostGIS, I need to manage it. > Other point, Feature ID in QGIS is still a short integer. > > Regards, > René-Luc > > Le 19/03/2020 à 10:28, Régis Haubourg a écrit : >> +1000. I was so relieved of the fid/oid/mapinfo_id when QGIS arrived and >> allowed business logic primary keys. >> >> >> Le jeu. 19 mars 2020 à 07:52, Nathan Woodrow <[email protected] >> <mailto:[email protected]>> a écrit : >> I agree. >> >> If there is an ID that is used internally as a unique primary key it should >> never be shown to the user. It should not be expected to be edited outside >> of the provider's control or be stable between edits. >> >> If you need a stable ID for reference you should make your own {{insert rant >> about people wanting to use increating ints as a reference ID}} >> >> On Thu, Mar 19, 2020 at 4:04 PM Nyall Dawson <[email protected] >> <mailto:[email protected]>> wrote: >> Hi list, >> >> Just wondering what everyone's thoughts are about geopackage FID >> columns. Personally, I find them an absolute nightmare to deal with, >> resulting in annoying (and dangerous) issues when trying to save >> geopackage edits, such as >> - field type issues: converting certain formats to geopackage fails, >> because existing fields with name "fid" are of an incompatible type >> with geopackage. Solution: manually uncheck the "fid" field from the >> "save as" dialog. >> - unique constraint violations: we've mostly fixed this in processing, >> but it's still unfortunately really common to get failures when saving >> edits to geopackage because some operation has resulted in duplicate >> fids. This can be a nightmare to fix, if it's even possible to do so. >> >> I personally HATE HATE HATE these columns, and would rather I never >> saw them ever again. Does anyone else feel the same? If so, could we >> potentially just permanently hide these columns from QGIS and avoid >> all these dangerous issues for users? >> >> Nyall >> _______________________________________________ >> QGIS-Developer mailing list >> [email protected] <mailto:[email protected]> >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> <https://lists.osgeo.org/mailman/listinfo/qgis-developer> >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> <https://lists.osgeo.org/mailman/listinfo/qgis-developer>_______________________________________________ >> QGIS-Developer mailing list >> [email protected] <mailto:[email protected]> >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> <https://lists.osgeo.org/mailman/listinfo/qgis-developer> >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> <https://lists.osgeo.org/mailman/listinfo/qgis-developer> >> >> _______________________________________________ >> QGIS-Developer mailing list >> [email protected] <mailto:[email protected]> >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> <https://lists.osgeo.org/mailman/listinfo/qgis-developer> >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> <https://lists.osgeo.org/mailman/listinfo/qgis-developer> > _______________________________________________ > QGIS-Developer mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer — Tim Sutton Co-founder: Kartoza Ex Project chair: QGIS.org Visit http://kartoza.com <http://kartoza.com/> to find out about open source: Desktop GIS programming services Geospatial web development GIS Training Consulting Services Skype: timlinux IRC: timlinux on #qgis at freenode.net I'd love to connect. Here's my calendar link <https://calendly.com/timlinux> to make finding time easy.
_______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
