diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2013-10-27 18:14:44 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2013-10-27 18:16:42 -0400 |
| commit | eb58107417d1ce956e6dfc1e4f809c8d50ba6168 (patch) | |
| tree | fd1ccb31c6b8ec3f40ac6ab192e8b04a5fa98700 /lib/sqlalchemy/dialects/postgresql | |
| parent | 64e32bda528fd34b264c4e6cd8b3369e9e0bc8ee (diff) | |
| download | sqlalchemy-eb58107417d1ce956e6dfc1e4f809c8d50ba6168.tar.gz | |
- Fixed bug where index reflection would mis-interpret indkey values
when using the pypostgresql adapter, which returns these values
as lists vs. psycopg2's return type of string.
[ticket:2855]
Conflicts:
doc/build/changelog/changelog_09.rst
lib/sqlalchemy/__init__.py
Diffstat (limited to 'lib/sqlalchemy/dialects/postgresql')
| -rw-r--r-- | lib/sqlalchemy/dialects/postgresql/base.py | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index a20cca702..1aaafac39 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -1929,11 +1929,14 @@ class PGDialect(default.DefaultDialect): table_oid = self.get_table_oid(connection, table_name, schema, info_cache=kw.get('info_cache')) + # cast indkey as varchar since it's an int2vector, + # returned as a list by some drivers such as pypostgresql + IDX_SQL = """ SELECT i.relname as relname, ix.indisunique, ix.indexprs, ix.indpred, - a.attname, a.attnum, ix.indkey + a.attname, a.attnum, ix.indkey::varchar FROM pg_class t join pg_index ix on t.oid = ix.indrelid |