From 1a35188b6903a48999ebbd1aeeec0114d3cbe7d3 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 25 Mar 2014 12:26:42 -0400 Subject: - 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 --- lib/sqlalchemy/dialects/postgresql/base.py | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'lib/sqlalchemy/dialects/postgresql/base.py') 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") ) -- cgit v1.2.1