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 gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.