On 5 Jan 2004, at 21:10, Sid Lane wrote:
on mysql 4.0.14-standard (x86 Linux) when I try the following:
alter table child_table add ( foreign key (column1, column2) references parent_table on delete cascade) ;
on an existing innodb table I get:
ERROR 1005: Can't create table './dbname/#sql-70f5_b92.frm' (errno: 150)
I know the script is syntactically correct since it was used to create the same
constraint on the same table (from same create_table script) on dev server so
I'm thinking there's something different in my installation/environment
(unfortunately I have to admit I didn't keep the best notes from building the
original "play" box).
any suggestions would be greatly appreciated!
Sid Lane DBA - Site Operations
Does this help?
http://groups.yahoo.com/group/SimpleORM/message/735
"WHAT is the average airspeed velocity of an unladen swallow?"
African or European? ;)
Steve.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
