Adding update/upsert functionality to Postgres PGVector Store node

Feature Requests Nodes
1

It would help if there was a node for:

My use case:

Currently (as of n8n 1.110.1) the Postgres PGVector Store node does not support updates. Unless there is a manually built codeblock for pre-processing the vector store to remove the existing content, this results in stale information and invalid responses from the LLM which is leveraging that stale information when deciding on the response.

Any resources to support this?

Are you willing to work on this?

I would be willing to work on adding this feature, if it would help facilitate the addition of it.
I’ve found references to developers leveraging the Langchain indexes API for handling the updates of PGVector store, though PGVector supports upserts and updates itself.