Hi Guillaume, The issue that you've faced looks strange - I've just tried to execute your first example causing the error on my 5.0.45 mysql server and tables were created ok. Can you post the code snippet causing the error?
Regards, Alex On 1 окт, 16:59, GustaV <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm experiencing an issue on MySQL (5.0.51a) when sqlalchemy create > the tables with foreign keys. > > The SQL issued : > CREATE TABLE `referenced` ( > `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY > ) TYPE = InnoDB; > > CREATE TABLE `referencing` ( > `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , > `f` INT NOT NULL, > FOREIGN KEY(f) REFERENCES referenced(id) > ) TYPE = InnoDB; > > I got an error (#1005 - Can't create table './seed-online/ > referencing.frm' (errno: 150) )... I solve this when I specify > explicitly the foreign key being an index (looks like it is the > "normal" way to do this) > > CREATE TABLE `referencing` ( > `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , > `f` INT NOT NULL, > INDEX(f), > FOREIGN KEY(f) REFERENCES referenced(id) > ) TYPE = InnoDB; > > But I don't know how to tell sqlalchemy to explicitely set that index. > On the other hand, at home (using wampserver2.0c, same version of > MySQL) it works : it looks like the index is set automatically if not > already set (I red this in the MySQL docs). > > So I'm looking for either : > - an option to tell sqlalchemy to set the index explicitely > - or, the option in MySQL to turn 'on' to have this INDEX > automatically! > > Thanks a lot! > > Guillaume --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
