drizzle-team/drizzle-kit-mirror

Generated migration for Postgres does not handle data type casting properly

Opened this issue · 0 comments

I am using postgres and had a table with primary key column of varchar data type, I changed it to uuid and generated a migration.
When I run the generated migration I am getting an error PostgresError: column "ticker_id" cannot be cast automatically to type uuid. I have attached the generated migration and the error I got from the database driver.
@AndriiSherman

Screenshot 2024-07-18 at 1 25 45 in the afternoon Screenshot 2024-07-18 at 1 25 30 in the afternoon