Re: [Sqlalchemy-tickets] [sqlalchemy] #1631: pg8000 not working with enums.

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

#1631: pg8000 not working with enums.
-----------------------------------+------------------------------------
      Reporter:  guest             |      Owner:  zzzeek
          Type:  defect            |     Status:  closed
      Priority:  medium            |  Milestone:  0.6.xx
     Component:  postgres          |   Severity:  no triage selected yet
    Resolution:  worksforme        |   Keywords:
Progress State:  completed/closed  |
-----------------------------------+------------------------------------

Comment (by tlocke):

 I've put up some code for adding enum support to PG8000 at
 https://github.com/tlocke/pg8000/tree/enum. This solution does need a
 cast, so the SQL that SA emits would need to look like:

 {{{
 INSERT INTO somes (e) VALUES (cast(%s as e)) RETURNING somes.some_id'
 ['one']
 }}}

 Would that work?

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