Issue with migration and guest role
Im getting this error when creating a new migration from my local:
ERROR: role "guest" does not exist (SQLSTATE 42704)
At statement 6: create policy "authenticated guests can insert comments"
on "public"."comments"
as permissive
for insert
to guest, authenticated
with check (true)
where its complaining the guest role does not exist, but it 100% does exist and allowed me to select it with the policy builder. Does anyone have any idea please?
ERROR: role "guest" does not exist (SQLSTATE 42704)
At statement 6: create policy "authenticated guests can insert comments"
on "public"."comments"
as permissive
for insert
to guest, authenticated
with check (true)
where its complaining the guest role does not exist, but it 100% does exist and allowed me to select it with the policy builder. Does anyone have any idea please?