Bug report #2423

spatialite: deleting columns is not allowed

Added by Giovanni Manghi about 13 years ago. Updated about 13 years ago.

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


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.



#1 Updated by Sandro Furieri about 13 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 about 13 years ago

  • Resolution set to invalid
  • Status changed from Open to Closed

Also available in: Atom PDF