S
Supabase2mo ago
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.)
1 Reply
JBTGG
JBTGGOP2mo ago
Solution is to manually modify latest migration file

Did you find this page helpful?