Hi! ----- Original Message ----- From: "Yasaswi Pulavarti" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, March 03, 2003 7:19 PM Subject: Re: Errors on ALTER table in InnoDB
> I don't know the answer. But I get similar errors when I use Erwin > (Data Modelling software) to publish or alter a database to my InnoDB > database. An expert's answer would be helpful. > Thanks, > Yasaswi > > [EMAIL PROTECTED] (My Deja) wrote in message news:<[EMAIL PROTECTED]>... > > When I try to alter some tables in InnoDB I some times get this sort of message. > > > > What do they mean? > > > > Error on rename of '.\transfer20\#sql-268_2' to '.\transfer20\exrates2' (errno: 150) > > ALTER TABLE EXRATES2 DROP COLUMN XR_DESTCURRENCY > > Error on rename of '.\transfer20\#sql-268_2' to '.\transfer20\exrates2' (errno: 150) The ALTER TABLE you are trying to do would make some FOREIGN KEY declarations not to obey the rules specified at http://www.innodb.com/ibman.html#InnoDB_foreign_keys. " Similarly, if an ALTER TABLE fails and it refers to errno 150, that means a foreign key definition would be incorrectly formed for the altered table " Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php