error: psycopg2.errors.UndefinedFunction: function similarity(text, text) does not exist

While tryig to create a similiarity search with postgres, bump into this error with this simple query

cur.execute("""
SELECT id, name, category, subcategory,
       (1 - (embedding <=> %s::vector)) AS semantic_score,
       similarity(name, CAST(%s AS text)) AS keyword_score,
       (0.7 * (1 - (embedding <=> %s::vector)) +
        0.3 * similarity(name, CAST(%s AS text))) AS final_score
FROM items
WHERE category = %s
ORDER BY final_score DESC
LIMIT 5;
""", (query_emb, query, query_emb, query, category))

To resolve this you need to activate pg_trgm extension. For some reason, I have to do it everytime and need to ensure that the extension is activated before my query can be successful.

Comments

Post a Comment

Popular posts from this blog

vllm : Failed to infer device type

Trying to run vllm without gpu will typicaly lands you into this issue. To resolve this issue: we can use set these both. Setting one does not work for me. So i had to configure both settings below:- 1.  environment variable CUDA_VISIBLE_DEVICES = "" 2. in the command line, change to use device cpu and remove  tensor-parallel-size. For example, python3 -m vllm.entrypoints.openai.api_server --port 8080 --model deepseek-ai/DeepSeek-R1 --device cpu --trust-remote-code --max-model-len 4096" References https://docs.vllm.ai/en/latest/getting_started/troubleshooting.html#failed-to-infer-device-type
Read more

android studio kotlin source is null error

Image
This org.jetbrains.kotlin.util.FileAnalysisException with a java.lang.IllegalArgumentException: source must not be null is a known issue that can sometimes occur with the Kotlin compiler. It seems to be related to how the compiler analyzes certain source code structures. When this happens, you need to go clean your project and do another rebuild.  For my case, I was trying to test out the databinding = true feature. 
Read more

gemini cli getting file not defined error

Image
 While trying to run gemini cli on my windows linux subsystem, i bump into this error here - "/Roaming/npm/node_modules/@google/gemini-cli/node_modules/undici/lib/web/webidl/index.js:512 webidl.is.File = webidl.util.MakeTypeAssertion(File)"  "ReferenceError: File is not defined" In Node.js, there’s no built-in File (until very recent Node 20+ with experimental WHATWG APIs). So, unless polyfilled, File is undefined, leading to the ReferenceError. And to resolve this, I had to upgrade to node 22 (might work for node 20) and then I was able to run it.
Read more