RE: strange behavior in foreign keys - Bartis, Robert M (Bob) - com.mysql.lists.mysql

2 messages in com.mysql.lists.mysqlRE: strange behavior in foreign keys

From	Sent On	Attachments
Bartis, Robert M (Bob)	28 May 2004 08:52
joao...@portugalmail.pt	28 May 2004 10:05

Subject:	RE: strange behavior in foreign keys
From:	Bartis, Robert M (Bob) (bar...@lucent.com)
Date:	05/28/2004 08:52:11 AM
List:	com.mysql.lists.mysql

Also, suggest you read
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html and in
particular look to see if you're getting error 1005 or 105 returned. That was
the purpose of my original question to you.

Bob

-----Original Message----- From: Victoria Reznichenko [mailto:vict...@ensita.net] Sent: Friday, May 28, 2004 11:42 AM To: mys...@lists.mysql.com Subject: Re: strange behaviour in foreign keys

joao...@portugalmail.pt wrote:

I've been running MySQL 4.0.x on a RH9 machine for some months and everything was fine. I could create tables of type InnoDB and define FOREIGN KEY's.... all was well.

A few days ago it does not let me create tables with foreign keys anymore.... it says something like "unable to create /databasename/tablename"...

If I remove the FOREIGN KEY constraint it accepts de table creation.

You have incorrect foreign key definition. Use SHOW INNODB STATUS command to see
more detailed error message.