On Jul 18, 2008, at 9:37 AM, Ryan Tracey wrote:
> sqlalchemy.exc.NoSuchTableError: manufacturer
>
> Just to sum up:
>
> dbengine = create_engine('mysql://u:[EMAIL PROTECTED]/schema1')
> meta = MetaData()
> meta.bind = dbengine
>
> Table('tableX', meta, autoload=True)
> ...
>
> Table('tableA', meta, autoload=True, schema='schema2')
> Table('tableB', meta, autoload=True, schema='schema2')
>
>
> tableX is okay, and tableA loads okay too. However tableB has a FK
> referencing tableA. Bang! I get a NoSuchTableError for tableA.
>
> I'll try get some ipython output. Or figure out how pdb works.
>
its likely mysql reflection doesn't yet know how to reflect cross-
schema foreign keys. put up a trac ticket with a short test case.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
