Hi Mike, I think I'm more perplexed than before. My search_path was correctly set. I put a breakpoint in my code after all of my classes and relationships are defined and after a call to configure_mappers(). I also turned "echo" on. The output is below. There are two confusing things. "metadata.tables" is empty, which is confusing since the code *does* insert things into the database, so it's not completely broken. When I execute the SQL command below by hand that generated the "sqlalchemy.exc.NoSuchTableError: server" error below, I get zero rows if the search path is set to "public", but the table is found if the search path includes the schema the table is in ("trillian"). I'm not sure how to proceed.
Thanks, Demitri ipdb> dbc.metadata.reflect() 2016-08-10 19:55:42,491 INFO sqlalchemy.engine.base.Engine SELECT relname FROM pg_class c WHERE relkind = 'r' AND 'trillian' = (select nspname from pg_namespace n where n.oid = c.relnamespace) 2016-08-10 19:55:42,491 INFO sqlalchemy.engine.base.Engine {} 2016-08-10 19:55:42,494 INFO sqlalchemy.engine.base.Engine SELECT c.oid FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE (pg_catalog.pg_table_is_visible(c.oid)) AND c.relname = %(table_name)s AND c.relkind in ('r', 'v', 'm', 'f') 2016-08-10 19:55:42,494 INFO sqlalchemy.engine.base.Engine {'table_name': 'server'} *** sqlalchemy.exc.NoSuchTableError: server ipdb> dbc.metadata.tables immutabledict({}) ipdb> dbc.metadata MetaData(bind=Engine(postgresql://trillian_admin:***@localhost:5432/trilliandb)) -- 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.