On Mar 18, 2009, at 9:39 PM, Tristan Seligmann wrote: > 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.
See http://www.sqlite.org/cvstrac/chngview?cn=6370 Beginning with the next release, the parser has been modified to allow INDEXED to be used as the name of a table or index or column. > > -- > 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 D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
