Bug report #2423
spatialite: deleting columns is not allowed
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Low | ||
| Assignee: |  nobody - | ||
| Category: | Data Provider | ||
| Affected QGIS version: | Regression?: | No | |
| Operating System: | All | Easy fix?: | No |
| Pull Request or Patch supplied: | Resolution: | invalid | |
| Crashes QGIS or corrupts data: | Copied to github as #: | 12483 |
Description
Is the spatialite provider supposed to allow deleting columns in the table of attributes? If yes then in QGIS (tested with trunk) this is not possible. If the answer is no, then please forgive me and close the ticket.
cheers
History
#1
Updated by Sandro Furieri almost 15 years ago
Sorry, deleting a column isn't allowed at all in SQLite.
You can add columns to any table after initial CREATE: but changing an already defined column is forbidden anyway.
Accordingly to this, renaming (or deleting) a column is not possible in SQLite/SpatiaLite.
Bye Sandro
#2
Updated by Giovanni Manghi almost 15 years ago
- Resolution set to invalid
- Status changed from Open to Closed