infinite recursion detected in policy for relation

What it means

One of your database security rules checks the same table it's protecting, which asks the rule again, forever. It's usually an 'is this user an admin?' check.

How to fix it: paste this prompt into your AI builder

Supabase says "infinite recursion detected in policy". Find the policy on that table that queries the same table (or a table whose policy queries back). Replace the lookup with a SECURITY DEFINER SQL function (in a non-exposed schema, with set search_path = '') that returns a boolean like is_admin() or is_member(team_id), and use that function in the policy. Give me the SQL migration. Don't loosen security or touch other tables' policies.

If the AI can't fix it: manual steps

1. Supabase dashboard, Database, Policies: find the policy causing it.

Where this happens

Seen in these AI app builders and editors:

Sources

• https://stackoverflow.com/questions/77592664/supabase-postgresql-rls-rule-leads-to-infinite-recursion-detected-in-policy-f
• https://supabase.com/docs/guides/database/postgres/row-level-security

Related database errors

• new row violates row-level security policy for table#2 · database
• Failed to send a request to the Edge Function / non-2xx status code#10 · database
• permission denied for table (Supabase 42501, missing GRANT)#11 · database
• Query returns empty [] with no error (but the table has data)#17 · database
• relation "public.x" does not exist / Could not find the table in the schema cache#24 · database
• Could not find the 'x' column in the schema cache (PGRST204) / column does not exist#25 · database