I'm trying to allow users to remove their email from a list of emails but I keep running into "new row violates row-level security policy for table "group_invitations"". I checked many times and the emails should be the exact same
. Censored it out but they match perfectly. Anyone know what's wrong with this?
create policy "Invited users can update their invitation" on group_invitations for update to authenticatedusing ( exists ( select 1 from group_invitations gi where gi.id = group_invitations.id and (auth.jwt() ->> 'email') = any(gi.invited_emails) ))with check (true);
create policy "Invited users can update their invitation" on group_invitations for update to authenticatedusing ( exists ( select 1 from group_invitations gi where gi.id = group_invitations.id and (auth.jwt() ->> 'email') = any(gi.invited_emails) ))with check (true);
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.