Re: [Sqlalchemy-tickets] [sqlalchemy] #2727: ProgrammingError when autoload from PostgreSQL (Amazon Redshift)

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

#2727: ProgrammingError when autoload from PostgreSQL (Amazon Redshift)
---------------------------+----------------------------------
      Reporter:  ashkop    |      Owner:  zzzeek
          Type:  defect    |     Status:  new
      Priority:  medium    |  Milestone:  0.8.xx
     Component:  postgres  |   Severity:  minor - half an hour
    Resolution:            |   Keywords:
Progress State:  in queue  |
---------------------------+----------------------------------
Changes (by zzzeek):

 * component:  cextensions => postgres
 * severity:  no triage selected yet => minor - half an hour
 * status_field:  awaiting triage => in queue


Comment:

 can you tell me if this patch helps please:

 {{{
 #!diff
 diff -r 7699a1080742 lib/sqlalchemy/dialects/postgresql/base.py
 --- a/lib/sqlalchemy/dialects/postgresql/base.py        Mon May 13
 16:13:15 2013 -0400
 +++ b/lib/sqlalchemy/dialects/postgresql/base.py        Wed May 15
 10:52:03 2013 -0400
 @@ -1802,7 +1802,7 @@
                      pg_class t
                      join pg_index ix on t.oid = ix.indrelid
                      join pg_attribute a
 -                        on t.oid=a.attrelid and a.attnum=ANY(ix.indkey)
 +                        on t.oid=a.attrelid and
 a.attnum=ANY(ix.indkey::smallint[])
                   WHERE
                    t.oid = :table_oid and ix.indisprimary = 't'
                  ORDER BY a.attnum
 }}}

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2727#comment:1>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python