Kapil, The other tables (users in this case) are already in place. They are in the 'web' schema, but SA is lookng in the public schema even though the web schema is defined with schema='web'.
The issue is that users.c.id should resolve to 'web.users.id', not 'users.id', because that's how users is defined. Randall Kapil Thangavelu wrote: > individual table creation (ddl) doesn't take into account dependencies, it > expects dependent tables to already be in place. > > as an alternative you can use. > > metadata.create_all() > > which will create tables bound to the metadata iff they don't exist, which > does take into account table fk dependencies. > > cheers, > > kapil > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
