Re: [sqlalchemy] Duplicate primary key on table migration

2018-03-26 Thread Mike Bayer
On Fri, Mar 23, 2018 at 7:41 PM, Colton Allen wrote: > I'm moving data from one table to another. During this move I'm preserving > the ID of the old table before dropping it. However, by doing so the > sequence gets out of whack and the database will no longer allow inserts to > the trigger tab

[sqlalchemy] Duplicate primary key on table migration

2018-03-23 Thread Colton Allen
I'm moving data from one table to another. During this move I'm preserving the ID of the old table before dropping it. However, by doing so the sequence gets out of whack and the database will no longer allow inserts to the trigger table. What can I do to fix the broken sequence? The id col