Hi, Trying to remove superfluous intermediate layers in a GPKG dataset. The general logic is
Ds = ogr.open(fp) Lyr = ds.executesql(query) Ds.DeleteLayer(idx) <- failed, database table is locked, may be caused by “sqlite3_exec(DROP TABLE “rtree_layername_geom”) failed: database table is locked Is layer deletion not supported while a “result set” from a SQL query is on the dataset is active? Perhaps importantly, the query sources the deleted layer. GDAL v3.9.3 Best, Jesse Lead Computer Scientist Science Systems and Applications, Inc. Dr Compton Tucker Team NASA Goddard Space Flight Center
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
