[Sqlalchemy-tickets] [sqlalchemy] #2819: VMware vFabric Postgres - Could not determine version from string

[sqlalchemy <mi...@zz...>]

#2819: VMware vFabric Postgres - Could not determine version from string
-------------------------------------+-------------------------------------
 Reporter:  sjschaefer               |           Owner:  zzzeek
     Type:  defect                   |          Status:  new
 Priority:  medium                   |       Milestone:  0.8.xx
Component:  postgres                 |        Severity:  trivial - <10
 Keywords:                           |  minutes
  postgres,vpostgres,vmware          |  Progress State:  awaiting triage
-------------------------------------+-------------------------------------
 SQL Alchemy Version: 0.8.2
 Python Version: 3.3
 Postgres Version: 9.2.4.0

 We are using VMware vFabric Postgres with SQLAlchemy. Unfortunately the
 version string returned by {{{select version()}}} isn't accounted for
 properly.

 Here is the string: {{{[PostgreSQL 9.2.4 ] VMware vFabric Postgres 9.2.4.0
 release build 1080137}}}

 The version check is located at:
 ''sqlalchemy/dialects/postgresql/base.py'' line 1547.

 The check uses re.match, which looks for the match only at the beginning
 of the string. The brackets in the return string (shown above) cause the
 match to fail.

 I changed re.match to re.search and this fixed the problem in my tests.

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2819>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python