DT
Drizzle Team•2d ago
Andersmmg

Drizzle-kit push not creating new column

I have a basic schema for a user, which I set up the database for using drizzle-kit push. I added a new avatar field to the users, and tried to use push to update the schema, but instead got this: LibsqlError: SQLITE_ERROR: no such column: avatar Looking at the generated SQL it's trying to copy over the new column, and doesn't try to create it. 
INSERT INTO `__new_users`("id", "name", "email", "avatar", "created_at") SELECT "id", "name", "email", "avatar", "created_at" FROM `users`;
INSERT INTO `__new_users`("id", "name", "email", "avatar", "created_at") SELECT "id", "name", "email", "avatar", "created_at" FROM `users`;
I'm not sure what I'm doing wrong, this seems very simple yet doesn't work.
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?