Hi,

What is the expected behavior if user asks ogr2ogr to create a SQLite database 
that already exists? The driver page http://www.gdal.org/drv_sqlite.html tells 
that
"The SQLite driver supports creating new SQLite database files, or adding 
tables to existing ones. Note that a new database file cannot be created over 
an existing file."

However, all these commands do overwrite the existing SQlite database

ogr2ogr -f sqlite -dsco spatialite=yes foo.sqlite foo.jml
ogr2ogr -f sqlite foo.sqlite foo.jml
ogr2ogr -f gpkg foo.gpkg foo.jml

But if I lock the existing database by creating a connection into it I get 
these messages:
ERROR 1: A file system object called 'foo.gpkg' already exists.
ERROR 1: gpkg driver failed to create foo.gpkg

Does "ERROR 1: A file system object called 'foo.gpkg' already exists." mean 
that the purpose to prevent overwriting but the check does not work? I have 
been using quit overwriting as a feature but is it actually a bug?

-Jukka Rahkonen-


_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to