[sqlalchemy] mysql table creation errno 105 when using vertical partitioning with InnoDB

2011-08-11 Thread Daniel Robbins
Hi there, I have been using ORM vertical partitioning for a while with MySQL 5.1.58 and MyISAM tables and SQLAlchemy 0.7.2. I have recently switched over to using InnoDB tables and my vertical partitioning table creation is failing part-way in with an errno 105 code. I have confirmed that all

Re: [sqlalchemy] mysql table creation errno 105 when using vertical partitioning with InnoDB

2011-08-11 Thread Michael Bayer
On Aug 11, 2011, at 2:04 PM, Daniel Robbins wrote: Hi there, I have been using ORM vertical partitioning for a while with MySQL 5.1.58 and MyISAM tables and SQLAlchemy 0.7.2. I have recently switched over to using InnoDB tables and my vertical partitioning table creation is failing

Re: [sqlalchemy] mysql table creation errno 105 when using vertical partitioning with InnoDB

2011-08-11 Thread Daniel Robbins
On Thu, Aug 11, 2011 at 12:20 PM, Michael Bayer mike...@zzzcomputing.comwrote: Vertical partitioning implies tables in separate databases or schemas. It seems like you have it set up such that a table in partition A can refer to a table in partition B using a schema qualifier. So if this is

Re: [sqlalchemy] mysql table creation errno 105 when using vertical partitioning with InnoDB

2011-08-11 Thread Michael Bayer
On Aug 11, 2011, at 2:57 PM, Daniel Robbins wrote: based on the sample code in the O'Reilly book Just FYI the Oreilly book is super, duper, extremely old and out of date.A good read through the documentation on the SQLAlchemy site should be more complete at this point and up to date,

Re: [sqlalchemy] mysql table creation errno 105 when using vertical partitioning with InnoDB

2011-08-11 Thread Daniel Robbins
On Thu, Aug 11, 2011 at 2:12 PM, Michael Bayer mike...@zzzcomputing.comwrote: Just FYI the Oreilly book is super, duper, extremely old and out of date. A good read through the documentation on the SQLAlchemy site should be more complete at this point and up to date, also stressing a whole