library · inferred from evidence
pgvector
A Postgres extension for vector similarity search, referenced in the context of the `vector` extension.
- 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 Advi
- Supabase pgvector match function: operator does not exist (extensions schema)
Two things to check. First, pgvector requires Supabase Postgres 15.1.0.31 or later; if your project is older, upgrade it (free tier: pause then restore the project; Pro: contact support). Second, install/enable the vector extension in the `