RE: strange behavior in foreign keys

[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 PROTECTED]
Sent: Friday, May 28, 2004 11:42 AM
To: [EMAIL PROTECTED]
Subject: Re: strange behaviour in foreign keys


[EMAIL PROTECTED] 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.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: strange behavior in foreign keys

[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 saying that I must create INDEXes for FOREIGN
KEYs to work properly.

I tried the example in that document and it works. Thanks again.

Any explanation why I never bumped into this before ?

jmf
__
O email preferido dos portugueses agora com 
100Mb de espaço e acesso gratuito à Internet
http://www.portugalmail.pt/servicos/email/gold/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]