Ticket #51 (closed defect: fixed)
Sqlite3 does not support dropping of columns
|Reported by:||rdreinet@…||Owned by:||andrew|
|Keywords:||sqlite3, alter, column, drop||Cc:|
Regarding http://www.sqlite.org/lang_altertable.html Sqlite3 does not support dropping or renaming of columns. Nevertheless South tries to and fails:
> document: 0003_docfolder = ALTER TABLE "document_documentfolder" DROP COLUMN "is_public" CASCADE;  **snip** File "/home/pascal/projects/march/lib/python2.5/site-packages/South-0.3-py2.5.egg/south/db/generic.py", line 333, in delete_column self.execute('ALTER TABLE %s DROP COLUMN %s CASCADE;' % params, ) File "/home/pascal/projects/march/lib/python2.5/site-packages/South-0.3-py2.5.egg/south/db/generic.py", line 33, in execute cursor.execute(sql, params) File "/home/pascal/projects/march/lib/python2.5/site-packages/Django-1.0.2_final-py2.5.egg/django/db/backends/sqlite3/base.py", line 168, in execute return Database.Cursor.execute(self, query, params) sqlite3.OperationalError: near "DROP": syntax error
I don't know how other migration frameworks handle this, but at least the delete_column-method should be implemented and throw a custom error message or something like that.