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 ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
