[gdal-dev] GeoPackage vector driver fails if layer name contains chars not compatible with SQLite

[Even Rouault]

Le mercredi 20 mai 2015 11:13:53, Stefan Keller a écrit :
> Hi Even
> 
> Just another small issue: GPKG can't handle pre-existing fid column name:
> >ogr2ogr -f "GPKG" outfile2.gpkg infile.geojson -nln layer_a
> 
> ERROR 1: sqlite3_exec(ALTER TABLE layer_a ADD COLUMN fid INTEGER) failed:
> duplic ate column name: fid

Stefan,

you should really try GDAL 2.0.0beta1. Has been fixed there too.

Admitedly burried in  http://svn.osgeo.org/gdal/trunk/gdal/NEWS:
"""
Cross driver changes:
 * SQLite, GPKG, PG, PGDump: in a newly created table, allow to create a 
integer field with same name of FID column (#5845)
"""

Even


> 
> --S.
> 
> 2015-05-18 18:50 GMT+02:00 Stefan Keller <sfkeller at gmail.com>:
> > Salut Even
> > 
> > 2015-05-18 17:40 GMT+02:00 Even Rouault <even.rouault at spatialys.com> a 
écrit :
> >> Le lundi 18 mai 2015 17:25:18, Stefan Keller a écrit :
> >>> Hi,
> >>> 
> >>> GeoPackage vector driver seems to fail if layer name contains chars
> >>> not compatible with SQLite (like dashes, '-').
> >> 
> >> Stefan,
> >> 
> >> This has been fixed in GDAL 2.0dev.
> > 
> > Merveilleux! Merci!!
> > 
> > -S.
> > 
> > 2015-05-18 17:40 GMT+02:00 Even Rouault <even.rouault at spatialys.com>:
> >> Le lundi 18 mai 2015 17:25:18, Stefan Keller a écrit :
> >>> Hi,
> >>> 
> >>> GeoPackage vector driver seems to fail if layer name contains chars
> >>> not compatible with SQLite (like dashes, '-').
> >> 
> >> Stefan,
> >> 
> >> This has been fixed in GDAL 2.0dev.
> >> 
> >> Even
> >> 
> >> --
> >> Spatialys - Geospatial professional services
> >> http://www.spatialys.com

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com