On Sep 11, 9:29 am, Richard <[email protected]> wrote: > Well, yesterday I changed a boolean type column to integer in my model > and all hell broke loose. > Fortunately all the boolean values were false so I was able to > manually enter postgres and do the update myself. > I never experienced such a problem with sqlite, perhaps because sqlite > is typeless (IIRC).
sqlite isn't typeless: http://sqlite.org/datatype3.html I've had exactly this kind of problem with using sqlite...changing column types isn't supported. Adding extra columns, & not using columns is fine... F --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
