-- EXISTS (SELECT 1 FROM public.profiles p WHERE p.id = auth.uid() AND p.role = 'admin') -- This queries the `profiles` table FROM WITHIN a policy ON `profiles`. -- Supabase evaluates RLS on every ...
If you are a SQL programmer, learning recursive SQL techniques can be a boon to your productivity. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of ...
-- Root cause: The UPDATE policy on `tasks` references `task_assignees`, -- whose SELECT policy in turn references `tasks`, creating a circular -- policy evaluation loop (42P17). -- Fix: Replace the ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results