summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects/postgresql/base.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2014-03-25 12:26:42 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2014-03-25 12:26:42 -0400
commit1a35188b6903a48999ebbd1aeeec0114d3cbe7d3 (patch)
treeef9126531e924eed5843d10ee1b461951c29d5b1 /lib/sqlalchemy/dialects/postgresql/base.py
parent74f7509d663641547054146a986a9634f9198857 (diff)
downloadsqlalchemy-1a35188b6903a48999ebbd1aeeec0114d3cbe7d3.tar.gz
- Fixed regression caused by release 0.8.5 / 0.9.3's compatibility
enhancements where index reflection on Postgresql versions specific to only the 8.1, 8.2 series again broke, surrounding the ever problematic int2vector type. While int2vector supports array operations as of 8.1, apparently it only supports CAST to a varchar as of 8.3. fix #3000
Diffstat (limited to 'lib/sqlalchemy/dialects/postgresql/base.py')
-rw-r--r--lib/sqlalchemy/dialects/postgresql/base.py5
1 files changed, 4 insertions, 1 deletions
diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py
index cea9d67b6..f69a6e010 100644
--- a/lib/sqlalchemy/dialects/postgresql/base.py
+++ b/lib/sqlalchemy/dialects/postgresql/base.py
@@ -2204,7 +2204,10 @@ class PGDialect(default.DefaultDialect):
t.relname,
i.relname
""" % (
- "::varchar" if self.server_version_info >= (8, 1) else "",
+ # version 8.3 here was based on observing the
+ # cast does not work in PG 8.2.4, does work in 8.3.0.
+ # nothing in PG changelogs regarding this.
+ "::varchar" if self.server_version_info >= (8, 3) else "",
self._pg_index_any("a.attnum", "ix.indkey")
)