On May 29, 2010, at 2:37 PM, jgarbers wrote: > I'm trying to do an in-place database "upgrade" -- if I detect that a > column is missing, I use ALTER TABLE to add the column and then > compute values for the new column for each row. I'd like this to all > happen within a transaction, so the column doesn't get added unless > the new values are successfully set.
to my knowledge sqlite does not support transactional DDL (seems to have some support, but its not fully operational). Postgresql and MS-SQL server do. SQLite has such limited ALTER TABLE support already its a poor choice for an ALTER intensive use case. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.