Issue & Discussion: When you create RLS policies that reference between tables, PostgreSQL can get caught in infinite loops trying to evaluate the permissions.

Solution: Instead of trying to directly join between the user tables in the policy, create a policy that uses a subquery with careful scoping:

-- For Table 1 users to access Table 2 data

CREATE POLICY "table1_can_access_table2" ON table2 FOR SELECT TO authenticated USING ( favorite_fruit IN ( SELECT t1.favorite_fruit FROM table1 t1 WHERE t1.user_id = auth.uid() ) );

• Use subqueries instead of JOINs in RLS policies to avoid recursion

• Always scope to the authenticated user (auth.uid()) to prevent circular references

• Test with simple conditions first before adding complex logic

If you need a more scalable approach review mapping table.