RE: strange behavior in foreign keys

2004-05-28 Thread joao . miguel . ferreira . 19740720
Victoria and Robert Thank you for your help. I think it is solved. The error was (as Robert said) "ERROR 1005: Can't create table './alex/jmf33.frm' (errno: 150)" I aslo checked "SHOW INNODB STATUS" where I was redirected to http://www.innodb.com/ibman.html There I found a link to a document sa

RE: strange behavior in foreign keys

2004-05-28 Thread Bartis, Robert M (Bob)
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:[EMAIL