The problem is that changing a type is not always well defined. In particular if you have data in the column the database may not be able to convert the data from the old type to the new type.
If you need to change a type the safe way if by deleting the column, run admin, add the column again of a new type. In this way postgresql will understand you are not trying to convert the data. On Jan 27, 3:37 pm, Johann Spies <johann.sp...@gmail.com> wrote: > It has happened several times now that I make changes in models/db.py > to the structure of a table (e.g. changing the type of a field) and > then web2py does not write the changes to the database (Postgresql) > and in the end one ends up with a situation that you have to do > changed using another interface to the database. > > How do I recreate a database setup using web2py? > > Regards > Johann -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
