RE: Error 150 on 3.23.51

2002-07-15 Thread James Kelty
t! But! MySQL to the rescue! It errored out (as you would expect). Thanks for all the help! -James -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 1:11 AM To: [EMAIL PROTECTED] Subject: Re: Error 150 on 3.23.51 James, - Original Message

Re: Error 150 on 3.23.51

2002-07-13 Thread Heikki Tuuri
James, - Original Message - From: ""James Kelty"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, July 13, 2002 12:43 AM Subject: Error 150 on 3.23.51 > Hello, > > We have compiled in InnoDB support for MySQL 3.23.51. We wo

Error 150 on 3.23.51

2002-07-12 Thread James Kelty
Hello, We have compiled in InnoDB support for MySQL 3.23.51. We would LOVE to take advantage of the transactions and foreign key assignments that it provides. We are having an issue, with the following SQL, however: All of the alter table statements are ending with this error: ERROR 1005: Can't