Bug report #7146
DB manager does not remove Spatialite indexes and entry in "spatialite_hystory" after deleting a table
|Affected QGIS version:||3.0.0||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||16210|
The same issue seems to affect also the browser.
Add a ector to a SL datasource, and select to create also a spatial index.
Then remove the vector from the datasource, the tables idx_tablename_geom* are not removed, as it isn't the entry in the table "spatialite_hystory", so it not possible to re-add another vector with the same name.
#5 Updated by Giuseppe Sucameli over 4 years ago
- Category changed from Data Provider/SpatiaLite to DB Manager
Similar issues are in both DBManager and SL dataprovider (importer), but the reported one occurs removing a vector table in DBManager. I'll file a new ticket for the importer (if not already there).
#6 Updated by R. R. over 3 years ago
Here on Win7 creating a new table with a previously used table name works, but the features are not displayed properly on the canvas. In QspatiaLite it's possible to delete unused indices as a workaorund.