Re: [Sqlalchemy-tickets] [sqlalchemy] #2922: Metadata.reflect failed on different schema foreign key constraint (postgresql)

[sqlalchemy <mi...@zz...>]

#2922: Metadata.reflect failed on different schema foreign key constraint
(postgresql)
----------------------------------+------------------------------------
      Reporter:  vrobin           |      Owner:  zzzeek
          Type:  defect           |     Status:  new
      Priority:  medium           |  Milestone:
     Component:  postgres         |   Severity:  no triage selected yet
    Resolution:                   |   Keywords:
Progress State:  awaiting triage  |
----------------------------------+------------------------------------

Comment (by zzzeek):

 first, make sure you read:
 http://docs.sqlalchemy.org/en/rel_0_9/dialects/postgresql.html#remote-
 cross-schema-table-introspection

 are you using an unusual search_path?


 next, please run the attached test case.  It includes your CREATE TABLE
 and code verbatim, it works fine for me.  Please alter it so that it
 illustrates your problem.

 Also note nothing has changed in 0.9 regarding how schemas are handled.

 So I have a feeling your search path is not set appropriately for how
 you're using the "schema" identifier here.

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2922#comment:2>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python