SELECT 1 FROM trip_members WHERE trip_id = check_trip_id AND user_id = auth.uid() AND role IN ('owner', 'editor') DROP POLICY IF EXISTS "Users can view trips they collaborate on" ON public.trips; DROP ...
-- 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) ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results