Hi! I'm having a bit of an issue where a table with a set schema is autoloaded. The table has a self-referential foreign key (it's a tree structure), which is having its referenced table loaded without a schema name. This, it seems, causes SQLAlchemy to stop dead when attempting to load objects from this table - it cannot find the foreign key relation (I assume it sees TABLENAME != SCHEMA.TABLENAME).
I saw a similar issue in this list about postgres, which did not seem to reach any definite conclusion. I'll put it simply. How can I make this work? I'm fine with not using explicit schemas at all, if I could set a default schema for everything (I have not been able to find a way to do this). The best option would be if the foreign keys were properly loaded with schema information. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---