1) actually migrations work better in posgresql because all types of alter tables are supported (http://www.sqlite.org/faq.html#q11).
For example if you change the type of a column with postgresql web2py will create a new column, try to convert the data, drop the old column, rename the old column. This may fail if data cannot be converted (like a string into an int with value that are not int). While sqlite does not handle column drop so web2py just does not do the migration. It just tried to parse the data when extracted according to the new column type. That migration can never fails because it never actually happens but it can lead to other problems later. 2) I have something to add about ondelete CASCADE but I will do it in another thread. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@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 -~----------~----~----~----~------~----~------~--~---
