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
and generated the migration with the standard
but during the
and generated the migration with the standard
npx drizzle-kit generate:pg commandbut during the
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?