I think this has to do with the web2py migration code. Maybe it only happens if the db is PostgreSQL. Now that I know that a default value should hopefully solve this its not an issue for me anymore. But I think it should not be necessary in first place, or if it is, it would be good if it would be mentioned in the documentation.
Alex