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  |
---------------------------+----------------------------------

Comment (by ashkop):

 Nope. But error changed:
 {{{
 sqlalchemy.exc.ProgrammingError: (ProgrammingError) cannot cast type
 int2vector to smallint[]
  "\n                SELECT a.attname\n                FROM\n
 pg_class t\n                    join pg_index ix on t.oid = ix.indrelid\n
 join pg_attribute a\n                        on t.oid=a.attrelid and
 a.attnum=ANY(ix.indkey::smallint[])\n                 WHERE\n
 t.oid = %(table_oid)s and ix.indisprimary = 't'\n                ORDER BY
 a.attnum\n            " {'table_oid': 165790}
 }}}

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