© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•3y ago•
7 replies
sik

how to convert serial to uuid type

Hello
I'm trying out drizzle but i'm stuck on a problem
I created a
todos
todos
table with id as
serial
serial
type, migrated and pushed it to my db, now I wanted to change the type to
uuid
uuid
but the following error appears on my console
PostgresError: column "id" cannot be cast automatically to type uuid
PostgresError: column "id" cannot be cast automatically to type uuid
image.png
image.png
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Changing `id` type from serial to uuid, causing error.
Drizzle TeamDTDrizzle Team / help
2y ago
Drizzle schema vs SQL when migrating serial id to uuid?
Drizzle TeamDTDrizzle Team / help
2y ago
Default UUID as text type
Drizzle TeamDTDrizzle Team / help
3y ago
serial type invalid in psql
Drizzle TeamDTDrizzle Team / help
2y ago