The problem is that adding notnull constraint causes a migration (except on sqlite).
Because the field exists already web2py creates a new tmp field, than tried to move existing data over. But the data contains Null while the new field is notnull=True therefore the migration will fail. On Saturday, 22 December 2012 21:12:54 UTC-6, Cliff Kachinske wrote: > > What happens if you add the field, set it to True,then add the notnull > constraint? --