this is an open issue right now due to
https://bitbucket.org/zzzeek/sqlalchemy/issue/2940/postgresql-array-uuid.
You can work around right now by calling psycopg2’s adapter globally:
import psycopg2.extras
psycopg2.extras.register_uuid()
or you can implement per-connection:
from sqlalchemy.engine import Engine
from sqlalchemy import event
@event.listens_for(Engine, "connect")
def connect(dbapi_connection, connection_record):
psycopg2.extras.register_uuid(None, dbapi_connection)
Weihua Zhu <[email protected]> wrote:
> Hi,
>
> We are using postgres and sqlalchemy. But now we are having problem to define
> a column which is a list of uuids because sqlalchemy always converted them
> into a list of string.
>
> Is there a good way to resolve this?
>
> Thanks,
> -Weihua
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
