Unable to retrieve from supabase vector DB node. Insert works fine, Supabase setup is all correct. Tested with meta data search and without but nothing comes back. Embeddings works fine, small embeddings setting. Running latest version (1.108.1), deleted and added node again but nothing works.
What is the error message (if any)?
Error searching for documents: 42P01 relation “documents” does not exist null
Again, not sure if it’s relevant, but there’s quite a few other functions in there in addition to the match_documents one. FYI I am using lovable for front end and it has made a lot of changes to the supabase DB functions, policies etc because of security profile.
Did you make any changes to the schema of the documents table or modified the definition of the match_documents function?
One thing you could try if you don’t have much information in the table yet - delete both documents table and match_documents function and recreate them (langchain template in SQL Editor).
Sorry for delay in response! You have been very helpful. I got it working again. I’m almost embarrassed to admit it but it was a credential issue. I used two different openAI credential for the node and embeddings node. At least I have gained a lot of knowledge about how vector DBs works, how to query functions in supabase, how to look through logs etc etc. Apologies for wasting your time!
