Peit
DTDrizzle Team
•Created by Peit on 4/14/2024 in #help
`ADD COLUMN` and `RENAME COLUMN` migration issues
Ran migrations with
drizzle-kit push:pg before, but that gives problems in our automated workflow because it asks interactively in case of deletions.
So now i want to run it with the drizzle migrator (from node-postgres) but that gives errors because columns already exist for ADD COLUMN statements. I've searched the discord and followed the suggestion to edit the migration files and add IF NOT EXISTS, that worked.
But now later migration files fail because there's RENAME COLUMN, and that operation doesn't have a IF NOT EXISTS option.
What can I do here? If possible I prefer not to edit migration files or the db directly.3 replies