Bug report #15832
cannot delete fields on a spatialite table
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Unknown | ||
| 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 |
Description
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).
Related issues
History
#1
Updated by Nyall Dawson about 8 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 about 8 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 about 8 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 about 8 years ago
See #8143 for more info.
#5
Updated by Jürgen Fischer about 7 years ago
- Category set to Unknown