Thomas Gelf schrieb: > db partitioning caused me some headache last days...
It's getting even worse. The following SQL will not work... > CREATE TABLE IF NOT EXISTS `msgs` ( > ... > PRIMARY KEY (`mail_id`,`partition_tag`), > FOREIGN KEY (`sid`, `partition_tag`) > REFERENCES maddr(`id`, `partition_tag`) ON DELETE RESTRICT, > ... > ) ... ...as MySQL 5.1 doesn't support foreign keys on partitioned tables. GREAT!!! *grrrrr* ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ 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/