]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
- Support has been improved for Postgresql reflection behavior on very old
authorMike Bayer <mike_mp@zzzcomputing.com>
Tue, 18 Feb 2014 23:35:23 +0000 (18:35 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Wed, 19 Feb 2014 21:02:29 +0000 (16:02 -0500)
commit4f29ebc72866e4d38d3a67b1f19ddc35cd2dbd74
treeaff725c69e3162db91c8f423b660f998d7f0a4f4
parentdd6884eafaaf5082b2050e52715b363b54e7c561
- Support has been improved for Postgresql reflection behavior on very old
(pre 8.1) versions of Postgresql, and potentially other PG engines
such as Redshift (assuming Redshift reports the version as < 8.1).
The query for "indexes" as well as "primary keys" relies upon inspecting
a so-called "int2vector" datatype, which refuses to coerce to an array
prior to 8.1 causing failures regarding the "ANY()" operator used
in the query.  Extensive googling has located the very hacky, but
recommended-by-PG-core-developer query to use when PG version < 8.1
is in use, so index and primary key constraint reflection now work
on these versions.

Conflicts:
doc/build/changelog/changelog_09.rst
test/dialect/postgresql/test_types.py
doc/build/changelog/changelog_08.rst
lib/sqlalchemy/dialects/postgresql/base.py
test/dialect/postgresql/test_dialect.py
test/dialect/postgresql/test_query.py
test/dialect/postgresql/test_reflection.py
test/dialect/postgresql/test_types.py