Bug report #2423

spatialite: deleting columns is not allowed

Added by Giovanni Manghi over 10 years ago. Updated over 10 years ago.

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 over 10 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 over 10 years ago

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

Also available in: Atom PDF