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 "WHAT is the average airspeed velocity of an unladen swallow?" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
