Re: [sqlalchemy] Copying enum from one column to another

On Wed, Mar 14, 2018 at 3:09 PM, Colton Allen wrote: > Casting raised this error: > > sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) cannot cast > type outcome_kind to trigger_event > > This is what it looks like in the select: > > cast(outcome.c.kind,

Re: [sqlalchemy] Copying enum from one column to another

On Wed, Mar 14, 2018 at 11:50 AM, Colton Allen wrote: > I'm trying to copy an enum of one type to an enum of another type. The > below is the query I'm using: > > import sqlalchemy as sa > > statement = sa.insert(table_a).from_select(['enum_a'], >

[sqlalchemy] Copying enum from one column to another

I'm trying to copy an enum of one type to an enum of another type. The below is the query I'm using: import sqlalchemy as sa statement = sa.insert(table_a).from_select(['enum_a'], sa.select(table_b .c.enum_b)) connection.execute(statement) Which raises this error in Postgres:

Re: [sqlalchemy] MySQL “charset introducer” how-to?

On Tue, Mar 13, 2018 at 8:26 PM, wrote: > Confirmed: adding `binary_prefix=true` to the URL gets rid of the warning. > > I’ll also keep an eye out for SA1.3, and will remove that string then. im going to make it look for the option so shouldn't break for you. > >