Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

spatialite: deleting columns is not allowed #12483

Closed
qgib opened this issue Feb 9, 2010 · 2 comments
Closed

spatialite: deleting columns is not allowed #12483

qgib opened this issue Feb 9, 2010 · 2 comments
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Data Provider Related to specific vector, raster or mesh data providers
Milestone
Version 1.5.0

Comments

@qgib
Copy link
Contributor

qgib commented Feb 9, 2010

Author Name: Giovanni Manghi (@gioman)
Original Redmine Issue: 2423

Redmine category:data_provider
Assignee: nobody -

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
@qgib
Copy link
Contributor Author

qgib commented Feb 9, 2010

Author Name: Sandro Furieri (Sandro Furieri)

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

@qgib
Copy link
Contributor Author

qgib commented Feb 9, 2010

Author Name: Giovanni Manghi (@gioman)

  • resolution was changed from to invalid
  • status_id was changed from Open to Closed

@qgib qgib added Bug Either a bug report, or a bug fix. Let's hope for the latter! Data Provider Related to specific vector, raster or mesh data providers labels May 24, 2019
@qgib qgib added this to the Version 1.5.0 milestone May 24, 2019
@qgib qgib closed this as completed May 24, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Data Provider Related to specific vector, raster or mesh data providers
Projects
None yet
Milestone
Version 1.5.0
Development

No branches or pull requests
1 participant
@qgib