Divmod Axiom[1] is a Python ORM built on SQLite; one of the book
keeping tables it creates in the database has a column named
"indexed", which became a reserved word around SQLite 3.6.4 (?). The
"obvious" fix for this problem is to simply quote the column name
using "", but the problem is that it is now impossible to load older
databases which didn't have the column created with the name quoted:

Error: malformed database schema (axiom_attributes) - near "indexed":
syntax error

What sort of migration path exists for converting / fixing these old
databases? Ideally there would be some mechanism that does not require
reinstalling an older version of SQLite.
-- 
mithrandi, i Ainil en-Balandor, a faer Ambar
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to