subject:"\[sqlalchemy\] Aliased FROM raises self_group\(\) error"

Re: [sqlalchemy] Aliased FROM raises self_group() error

2018-03-23 Thread Mike Bayer

On Fri, Mar 23, 2018 at 6:58 PM, Colton Allen wrote: > I'm trying to reset my primary key sequence and its raising a weird error. > My primary key is a UUID. > > op.execute( > sa.select([ > sa.func.setval( > 'trigger_id_seq', > sa.select([sa.func.max(trigger

[sqlalchemy] Aliased FROM raises self_group() error

2018-03-23 Thread Colton Allen

I'm trying to reset my primary key sequence and its raising a weird error. My primary key is a UUID. op.execute( sa.select([ sa.func.setval( 'trigger_id_seq', sa.select([sa.func.max(trigger.c.id)]). alias('max_trigger_id') ) ]) )