`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.
Was this page helpful?