[FEATURE] add a postgresql record manager in agent flows

[bodzebod]

Describe the feature you'd like
I'm building an agent flow and I'm using postgresql with pgvector as a vector database in order to be able to upload files via the chat.
However, there's no record manager to avoid duplicate upserts. Please can you make it available in agentflows? Thank you!

Additional context

[isikepalaku]

same here

[isikepalaku]

when upsert using postgresql record manager using supabase

[bodzebod]

@isikepalaku this ticket is a feature request, not a bug report. You must open a bug report for raising issues.

[HenryHengZJ]

Can you try using Document Store?

You can setup embeddings, vector store, record manager from there, then use it within the chatflow/agentflow

[bodzebod]

hi @HenryHengZJ , I aim at allowing a file upsert from the chat UI. I'm not sure if using document stores allows that.
In addition, I want to be able to upsert text files (mainly application log files). When adding a File loader in a document store, there's no options for setting up the record manager and vector store. It gives this option for PDF loader.

[shanequ]

I am using Milvus and hope the record manager can be available in agent flow as well.