Bug report #15832

cannot delete fields on a spatialite table

Added by Donovan Cameron over 4 years ago. Updated almost 4 years ago.

Affected QGIS version:2.18.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:up/downstream
Crashes QGIS or corrupts data:No Copied to github as #:23752


I've created a spatialite database with three spatialite tables (pt, ln, ply) and started an editing session on one of the tlus_* tables.

From the attribute table, I can add a field, but the delete field button at the top of the attribute table window is greyed out.
As a result, fields cannot be dropped from the spatialite table.

I've attached a spatialite table for reference.

This is experienced on Windows (OSGeo4W, qgis-rel-dev), MacOSX (KyngChaos), Linux (arch linux, git release branch).

imw2016_da3.sqlite.tar.gz - example spatialite table (402 KB) Donovan Cameron, 2016-11-10 10:29 AM

Related issues

Related to QGIS Application - Feature request #8143: Add tooltip about why users cannot delete columns in Spat... Closed 2013-06-24


#1 Updated by Nyall Dawson over 4 years ago

  • Resolution set to up/downstream
  • Status changed from Open to Closed

This is a (extremely frustrating and prohibitive) limitation in the sqlite data format which is used by spatialite:


#2 Updated by Donovan Cameron over 4 years ago

Aw, what a sad story.

It'd be nice to see a portable db format that allows field deletion but also has spatial functions! I guess right now I can't expect the best of both worlds..

#3 Updated by Paolo Cavallini over 4 years ago

I think this is solved with a bit of a hack in Spatialite netive GUI. Maybe we could get inspiration from it.

#4 Updated by Saber Razmjooei over 4 years ago

See #8143 for more info.

#5 Updated by Jürgen Fischer almost 4 years ago

  • Category set to Unknown

Also available in: Atom PDF