-- causing Postgres to detect infinite recursion. -- Solution: use a SECURITY DEFINER function to bypass RLS for the check. -- Drop whichever policy name exists (old name on local, new name on remote) ...

Abstract: SQL:1999 recursive queries are almost a quarter century old. In this standard the recursive queries have the form of recursive common table expressions. In recent years vendors of almost all ...

-- This triggers the users table's own RLS policies, which may in turn -- query other tables, causing policy-chain recursion until Postgres -- hits the stack depth limit. -- Fix: Wrap the admin check ...

Abstract: Privacy-preserving collaborative data analysis is a popular research direction in recent years. Among all such analysis tasks, privacy-preserving SQL ...