Drizzle TeamDT
Drizzle Team•12mo ago
ac222222222222

drizzle-kit generate keeps trying to recreate enum value that already exists

I recently created a migration using 
drizzle-kit generate
 after replacing a pg enum value. the generated migration was incorrect as it added the new value but never removed the old one. Hence, I manually edited the migration to look like this:
ALTER TYPE job_status RENAME VALUE 'completed' TO 'successful';

however, now whenever I run generate for subsequent migrations, it keeps trying to create the new enum value:
ALTER TYPE "job_status" ADD VALUE 'successful';--> statement-breakpoint

is there a way to stop it from doing so?
Was this page helpful?