I'm running SQLAlchemy 1.2.12.  When trying to autoload a DB2 table, it 
gives me a "no such table" error for a table referenced in a foreign key, 
even though that table exists.

    import sqlalchemy
    
    cnxstr = 'ibm_db_sa://xyzzy'
    db2 = sqlalchemy.create_engine(cnxstr)
    meta = sqlalchemy.MetaData(db2)    
    tbl = sqlalchemy.Table('child_table', meta, schema='plugh', 
autoload_with=db2)
    
    NoSuchTableError: parent_table

Not that this code works fine -- SQLAlchemy is able to find the parent 
table in other contexts.

    tbl = sqlalchemy.Table('parent_table', meta, schema='plugh', 
autoload_with=db2)

I'm also able to construct the tables by hand using the inspector.  It's 
only when I use Autoload that I run into this problem.  Is there a way to 
fix the autoload?

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to