|
From: Mark M. <Mar...@ij...> - 2010-03-17 12:28:50
|
Marc, > ERROR 1506 (HY000): Foreign key clause is not yet supported in > conjunction with partitioning > > Even this the table schema without (see above) it does not work: > ERROR 1005 (HY000): Can't create table 'amavisd_log.msgs' (errno: 150) > > shell> perror 150 > MySQL error code 150: Foreign key constraint is incorrectly formed > > How can I use all the tables above with partitioning or is this not > recommended? Try removing all FOREIGN KEY constraints, these are not essential. Mark |