In this case you have to write a script to do it. This kind of failure is usually very easy to recover from except if you use MySQL. MySQL does not allow multiple ALTER tables in the same transaction hence it can get into an odd state where some tables have been altered and some have not. You can still recover but you may need some info about what happens under the hood.
Massimo, true to your observation. My experience in a mature DB environment is, you pretty much have to burn incense and make table sacrifices to get the DB team to be willing to alter any tables. So many apps have gone before that depend on certain table structures that ALTER is reserved for root privilege. I rarely run up against the limitation. JohnMc --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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 -~----------~----~----~----~------~----~------~--~---
