On Wed, Oct 31, 2018 at 11:00 AM Riccardo Magliocchetti <riccardo.magliocche...@gmail.com> wrote: > > Hello, > > we'd like to use Postgresql xmin column for optimistic concurrency, so we > declared the column as: > > xmin = Column("xmin", Integer, system=True, server_default=FetchedValue()) > > > The problem is when autogenerating a migration with alembic (via > flask-migrate) the xmin column is added to > the operations so the migrations fails.
is the column generated inside the migration including the "system=True" flag? if that flag is present then the column won't be created. Or are you referring to an alter table operation? Need specifics on the failure and then we need to post a bug report if there is in fact a problem. I've grepped the alembic source code for "system" and haven't found > something sensible so wondering if alembic should check if the system > attribute of the column is set and > if so ignoring the column. > > Thanks, > Riccardo Magliocchetti > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy-alembic" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy-alembic+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "sqlalchemy-alembic" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy-alembic+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.