Drizzle migration error
Whenever i try running drizzle-kit push, I get hit with the same error:
error: column "id" is in a primary key
Using Postgres
4 Replies
we need more context, can you provide the code and the exact error trace?
had to send msg as file :/
Drizzle fails because it tries to recreate a column id that is already a primary key in the database. The schema must be synchronized: either delete the tables and run drizzle-kit push, or better yet, use migrations (generate + migrate) to avoid the conflict.