has this changed since sqlite2? SQLite is "typeless": http://www.sqlite.org/datatypes.html
On Sep 11, 7:01 pm, Fran <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
