Supabase pgvector triggers Function Search Path Mutable security warning
Pin the operator to its schema: replace with OPERATOR(extensions. ) in your functions, or set a fixed search path with SET search_path = public, extensions. Both were confirmed working in the thread and satisfy the Security Advisor's immutable-path requirement while keeping pgvector distance queries functi…
Problem outcome: unknown