Thorsten,
>This is right, but on these columns has to be an index set on before you can create
>foreign keys with innodb.
>
>So, create the indexes and AFTER that the foreign keys and it should work : )
Thanks for the clarification !
However, moving the foreign key definitions after the table and index creation
statements does not
remove the problem. More indexes are necessary.
This seems to be an incompatibilty with Oracle where only the referenced item has to
be indexed. :-((
I request that the error message given by the 4.1 system could be improved to avoid
this confusion and better
explain the reason why it failed.
--
regards,
Ian Hartas
---------------------------------------------
"Pluralitas non est ponenda sine neccesitate"
Occam's Razor.
---------------------------------------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
