From f9f80215918346582ba262ff1e2e63e4ea17a8f7 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Fri, 13 Jan 2006 01:14:52 +0000
Subject: [PATCH] on foreign key default schema is that of the parent column

---
 lib/sqlalchemy/schema.py | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

diff --git a/lib/sqlalchemy/schema.py b/lib/sqlalchemy/schema.py
index efa4c02e1c..86613ade98 100644
--- a/lib/sqlalchemy/schema.py
+++ b/lib/sqlalchemy/schema.py
@@ -376,8 +376,7 @@ class ForeignKey(SchemaItem):
                     raise ValueError("Invalid foreign key column specification: " + self._colspec)
                 if m.group(3) is None:
                     (tname, colname) = m.group(1, 2)
-                    # use default schema
-                    schema = None
+                    schema = self.parent.original.table.schema
                 else:
                     (schema,tname,colname) = m.group(1,2,3)
                 table = Table(tname, self.parent.engine, mustexist=True, schema=schema)
@@ -482,4 +481,4 @@ class SchemaVisitor(object):
         pass
 
             
-            
\ No newline at end of file
+            
-- 
2.47.2