Re: [gdal-dev] GPKG: Drop table but how to drop the rest?

2016-10-05 Thread Even Rouault
Le jeudi 29 septembre 2016 13:13:17, Even Rouault a écrit : > Hi Jukka, > > > I wonder if it could be possible to do something like "DROP CASCADING" in > > GeoPackage and delete the spatial index by the same. > > I will work in a short term on this (as well as renaming columns) Jukka, I wrote

Re: [gdal-dev] GPKG: Drop table but how to drop the rest?

2016-09-29 Thread Even Rouault
Hi Jukka, > > I wonder if it could be possible to do something like "DROP CASCADING" in > GeoPackage and delete the spatial index by the same. I will work in a short term on this (as well as renaming columns) The "usual" syntax "ogrinfo -sql 'DELLAYER:bar' foo.gpkg" will be available, and

[gdal-dev] GPKG: Drop table but how to drop the rest?

2016-09-29 Thread Rahkonen Jukka (MML)
Hi, I wonder if it could be possible to do something like "DROP CASCADING" in GeoPackage and delete the spatial index by the same. It will for sure be unusable once the table is dropped. I feel that SQLite does not support that because cascading drop seems to require that parent and child