Problem deleting rows in a Postgres Vector store

I have copied the workflow from Nate's "Step by Step: RAG AI Agents Got Even Better", which worked great. I'm now making a change where I am swapping out the "Superbase vector store" with a "Postgres vector store”, I have the vector store working , adding files working and chatting with the agent working..

However, I’m encountering an issue with deleting rows from the “vectors” table in the Postgres vector store. Specifically, I want to delete selected rows from the Postgres vector store data when updating a Google Doc that’s already in the vector store. This process involves creating new vectors from the latest version of the Doc and removing old vectors related to the previous version.

I have been trying to setup the Postgres delete node but, I keep getting an error when attempting to find and delete the correct rows. Any assistance in how to configuring n8n to delete rows from a Postgres vector store would be greatly appreciated.

4 comments