Drizzle TeamDT
Drizzle Team•2y ago
Peit

`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?