9 replies

Migrations with new notNull() columns

what's the proper way to add a notNull() column through a migration? I just tried to add a column in my schema like

  foo: text('foo').notNull()

  foo: text('foo').notNull()

and generated the migration with the standard

npx drizzle-kit generate:pg

npx drizzle-kit generate:pg

command

but during the

await migrate(...)

await migrate(...)

call, I get an error that existing rows have a NULL value (which, yes... i'm just adding the column now). I don't see anything in the docs about customizing migrations to backfill existing rows in cases like this. Is there a way to properly handle this?

Migrations with new notNull() columns

Similar Threads

Migrations with new notNull() columns

Similar Threads

Similar Threads

Similar Threads