diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2011-09-09 17:12:52 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2011-09-09 17:12:52 -0400 |
| commit | 843847740c7fd3705cb7804ac62914b9a77dc174 (patch) | |
| tree | 7758987cac6ffa3aef1bcd9ad8899bdb29561060 /lib/sqlalchemy/dialects/postgresql/base.py | |
| parent | bb978f2e0a4c455b28825aed3fcc80bf70f09c49 (diff) | |
| download | sqlalchemy-843847740c7fd3705cb7804ac62914b9a77dc174.tar.gz | |
- Reflection functions for Table, Sequence no longer
case insensitive. Names can be differ only in case
and will be correctly distinguished. [ticket:2256]
Diffstat (limited to 'lib/sqlalchemy/dialects/postgresql/base.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/postgresql/base.py | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index 5ff20ce73..8c3babd31 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -938,9 +938,9 @@ class PGDialect(default.DefaultDialect): sql.text( "select relname from pg_class c join pg_namespace n on " "n.oid=c.relnamespace where n.nspname=current_schema() and " - "lower(relname)=:name", + "relname=:name", bindparams=[ - sql.bindparam('name', unicode(table_name.lower()), + sql.bindparam('name', unicode(table_name), type_=sqltypes.Unicode)] ) ) @@ -949,10 +949,10 @@ class PGDialect(default.DefaultDialect): sql.text( "select relname from pg_class c join pg_namespace n on " "n.oid=c.relnamespace where n.nspname=:schema and " - "lower(relname)=:name", + "relname=:name", bindparams=[ sql.bindparam('name', - unicode(table_name.lower()), type_=sqltypes.Unicode), + unicode(table_name), type_=sqltypes.Unicode), sql.bindparam('schema', unicode(schema), type_=sqltypes.Unicode)] ) @@ -966,9 +966,9 @@ class PGDialect(default.DefaultDialect): "SELECT relname FROM pg_class c join pg_namespace n on " "n.oid=c.relnamespace where relkind='S' and " "n.nspname=current_schema() " - "and lower(relname)=:name", + "and relname=:name", bindparams=[ - sql.bindparam('name', unicode(sequence_name.lower()), + sql.bindparam('name', unicode(sequence_name), type_=sqltypes.Unicode) ] ) @@ -978,9 +978,9 @@ class PGDialect(default.DefaultDialect): sql.text( "SELECT relname FROM pg_class c join pg_namespace n on " "n.oid=c.relnamespace where relkind='S' and " - "n.nspname=:schema and lower(relname)=:name", + "n.nspname=:schema and relname=:name", bindparams=[ - sql.bindparam('name', unicode(sequence_name.lower()), + sql.bindparam('name', unicode(sequence_name), type_=sqltypes.Unicode), sql.bindparam('schema', unicode(schema), type_=sqltypes.Unicode) |