Hey Ergo, Thanks for the reply.
I wonder what will happen to the performance when trying to drop and recreate the foreign key constraints if the table has thousands of data(lets say 50k)? Regards Pravin B On Monday, 23 July 2012 19:02:23 UTC+5:30, Ergo wrote: > > Hi Pravin, > > The problem you are seeing here is probably related to the fact you have > some other foreign keys that rely on the user_id column, Mysql will do > everything to make your life miserable if you change the name of the > column/size of type that has other constraints depend on it - and the error > message is not exactly helpful here. > > To fix your issue you will have to first drop the other constraints that > depend on the column, then rename it, and then recreate constraints again. > > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/N4Y43tZR3LEJ. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
