© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•5mo ago•
1 reply
JBTGG

Supabase db pull, cast error

Hey, I’m getting an error while creating a migration file:

ERROR: cannot cast type int4range to bigint (SQLSTATE 42846)                                   
At statement: 105                                                                              
alter table "public"."dimensions" alter column "bust" set data type bigint using "bust"::bigint
ERROR: cannot cast type int4range to bigint (SQLSTATE 42846)                                   
At statement: 105                                                                              
alter table "public"."dimensions" alter column "bust" set data type bigint using "bust"::bigint


In the previous version of the table, I had the bust column as bigint, but now I’ve changed it to int4range. How can I edit the migration file manually to make this work with Supabase? (After running supabase db pull, the migration file is not created — I only get this error.)
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

supabase db pull
SupabaseSSupabase / help-and-questions
13mo ago
supabase db pull
SupabaseSSupabase / help-and-questions
3y ago
Trying db pull on supabase
SupabaseSSupabase / help-and-questions
12mo ago
supabase db pull error running container: exit 1
SupabaseSSupabase / help-and-questions
3mo ago