On Fri, Mar 23, 2018 at 6:58 PM, Colton Allen <[email protected]> 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.c.id)]).alias('max_trigger_id') > ) > ]) > ) > > # raises: self_group() got an unexpected keyword argument 'against'
this is likely https://bitbucket.org/zzzeek/sqlalchemy/issues/3939 which is fixed in 1.2. however, just don't use alias() in that context, use .as_scalar().label('max_trigger_id') instead since you want this to be a scalar column expression. > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > 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 https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
