Neon Column Name Collision on Migrate
Hey folks, I'm developing a project using Neon PostgreSQL with drizzle in the client side. I added a column in my table three days ago, which is called "status", that was done through the drizzle schema. I ran db generate, migrate and push, but I'm not sure if it worked at the time.
In my Neon __drizzle_migrations table I can only see one entry. In my local _journal, I have two entries. Whenever I try to migrate now in my local database it returns a long error:
I have tried basically everything so far, pulling the database, removing the migration file and from the journal manually, tried introspect, tried to generate and migrate again, but it seems that nothing works.
When I try to push it says everything is synched already. Any clues? 😫
1 Reply
"solved" by manually including a new migration record in the __drizzle_migrations. I hope that won't cause any future troubles