Need help with pushing local changes to supabase remote
When I tried db push I got the below error. I don't know how to resolve it. Do I need to drop the RLS policies for this to work?
I'm have my project on supabase.com
ERROR: cannot alter type of a column used in a policy definition (SQLSTATE 0A000)
policy Allow AMDIN to insert subscription data on table subscriptions depends on column "role"
At statement: 9
alter table "public"."profiles" alter column role type "public"."user_role" using role::text::"public"."user_role"
I'm have my project on supabase.com
ERROR: cannot alter type of a column used in a policy definition (SQLSTATE 0A000)
policy Allow AMDIN to insert subscription data on table subscriptions depends on column "role"
At statement: 9
alter table "public"."profiles" alter column role type "public"."user_role" using role::text::"public"."user_role"
