[Qgis-user] QGIS not seeing any GUID fields belonging to geopackage tables that contain geometry fields.

[Ludwig Kniprath]

Hello Dennis,

I don't know I understood your problem, but a GeoPackage is internally a 
SQlite-Database with SpataLite-extension and without native field-types 
GUID or UUID.

The SpatiaLite-provided function CreateUUID  "returns a Version 4 
(random) UUID (Universally unique identifier)" 
(https://www.gaia-gis.it/gaia-sins/spatialite-sql-5.0.1.html). These 
values can be stored in text or blob-columns, perhaps as default-value 
and primary key, which then are usable in QGis as any other 
text/blob-column.

I don't know a QGis-JOIN-function (?), but I successfully tested the 
*SQL*-JOIN-Syntax in QGis DB-Manager and as source for a virtual layer 
joining two tables via two columns type "text" containing common 
CreateUUID-generated UUIDs (QGis 3.40.3 under Linux).

hth

Ludwig


Am 02.02.25 um 01:36 schrieb dennis mckay via QGIS-User:
> I am building several interconnected geopackage tables.  I am using 
> the JOIN function in QGIS (3.40.2, OSGeo4W, Windows 10) where I 
> noticed that the GUID fields do not appear as possibilities, nor do 
> they appear under Properties > Fields.  All my JOINS are with GUID fields.
>
> With tables without geometries, the GUID fields appear and will join 
> together nicely.  In Spatiallite.exe, looking at the same geopackage 
> file, these GUID fields appear.  QGIS also recognizes these GUIDs in 
> identical tables in PostGIS, where they are joined together nicely.
>
> I would like help understanding how to get QGIS to recognize these 
> GUID fields, or is this behavior a "feature"?
>
> Dennis K. McKay
> Retired Federal Cadastral Surveyor
>
>
> _______________________________________________
> QGIS-User mailing list
> QGIS-User at lists.osgeo.org
> List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250202/bc21d792/attachment.htm>