In my first experiments with elixir I noticed that sqlalchemy doesn't
handle foreign keys correctly on autoloaded tables. This has to to
with schema handling in the postgresql driver. A foreign key
referencing a table in the public schema from "outside" gets the table
name without the schema part and thus locates the table in its own
schema. I've appended a trivial fix below.
Best regards
Klaus
--- databases/postgres.py.orig 2007-04-30 06:08:16.000000000 +0200
+++ databases/postgres.py 2007-05-18 12:15:15.000000000 +0200
@@ -478,6 +478,8 @@
constrained_columns =
[preparer._unquote_identifier(x) for x in re.split(r'\s*,\s*',
constrained_columns)]
if referred_schema:
referred_schema =
preparer._unquote_identifier(referred_schema)
+ else:
+ referred_schema =
self.get_default_schema_name(connection)
referred_table =
preparer._unquote_identifier(referred_table)
referred_columns = [preparer._unquote_identifier(x)
for x in re.split(r'\s*,\s', referred_columns)]
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
