In a secondary table used for many to many relationships, usually a foreign key exists for both tables. Each of those fields is both a primary key and a foreign key. When defining a table with sqlalchemy, any field with primary_key=True and Integer type is created as a Serial type. This is not appropriate for secondary tables since they use values from their foreign keys.
Randall Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users