> > > > In particular, me an Nyall have been chatting about adding a method to > factory a QgsVectorLayer from a generic SQL query, the issues I see is that > we need a PK (at least for PG) and how to decide the geometry column if > there are more than one. >
I wonder if you could just transparently add row_number[1] to the query to give each row a unique id? Regards Tim [1] https://www.postgresqltutorial.com/postgresql-row_number/ -- ------------------------------------------------------------------------------------------ Tim Sutton Visit 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 Tim is a member of the QGIS Project Steering Committee ------------------------------------------------------------------------------------------- Kartoza is a merger between Linfiniti and Afrispatial
_______________________________________________ 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
