Re: [gdal-dev] Implications of "Multi-column primary key in [table] to supported" warning

2022-03-04 Thread DUTRIEUX Loic
ociation tables, you guessed right, the composite key is gone and an additional ogc_fid primary key is added. Thanks again, Kind regards, Loïc From: Rahkonen Jukka (MML) Sent: 03 March 2022 13:55:33 To: DUTRIEUX Loic (JRC-ISPRA); gdal-dev@lists.osgeo.org Subje

[gdal-dev] Implications of "Multi-column primary key in [table] to supported" warning

2022-03-03 Thread DUTRIEUX Loic
Hi everyone, Quick question, I'm using ogr2ogr to clone a postGIS database to a spatialite file database (by the way, very convenient that ogr2ogr handles the transfer of non-spatial tables too). The database contains many-to-many relations and as a consequence association tables with multiple