> > 2. no synonym parameter, schema = 'AINV_OWNER' on Table(...)
> > Results in the error: "Could not determine join condition between
> > parent/child tables..." I had expected this to work but it seems that
> > for some reason SQLA doesn't see the constraint info on tables in
> > another user's schema. Is that a bug?
>
> that would be a bug, yes.   but, try specifying schema and all the names
> using lowercase characters (not ALL_UPPERCASE as you may be doing) - SQLA
> will ensure that it uses case insensitive identifiers (it converts to
> uppercase as needed when talking to oracle).  its possible that there is a
> mismatch between target names and specified names causing this issue.  or
> maybe the oracle dialect just doesn't interpret the "owner" part of a
> foreign key constraint correctly yet (im not easily able to test things
> like that with Oracle XE).

That did the trick!

Thanks a lot,
Sven

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to