Unable to write data to a pgvector table with schema when collection is configured

Questions
1

I am using pgvector store node to write data to DB, and I have configured collection, but when I specify schema, I get the following error. If I don’t specify schema, data can be written successfully. How should I solve this problem?

Error msg : Error adding column or creating index: syntax error at or near “.”

Detail error info :
Error: Error adding column or creating index: syntax error at or near “.” at PGVectorStore.ensureCollectionTableInDatabase (C:\Users\xxx_user\AppData\Roaming\npm\node_modules\n8n\node_modules@langchain\community\dist\vectorstores\pgvector.cjs:690:23) at processTicksAndRejections (node:internal/process/task_queues:105:5) at Function.initialize (C:\Users\xxx_user\AppData\Roaming\npm\node_modules\n8n\node_modules@langchain\community\dist\vectorstores\pgvector.cjs:332:13) at Function.fromDocuments (C:\Users\xxx_user\AppData\Roaming\npm\node_modules\n8n\node_modules@langchain\community\dist\vectorstores\pgvector.cjs:727:26) at Object.populateVectorStore (C:\Users\xxx_user\AppData\Roaming\npm\node_modules\n8n\node_modules@n8n\n8n-nodes-langchain\nodes\vector_store\VectorStorePGVector\VectorStorePGVector.node.ts:274:3) at Object.execute (C:\Users\xxx_user\AppData\Roaming\npm\node_modules\n8n\node_modules@n8n\n8n-nodes-langchain\nodes\vector_store\shared\createVectorStoreNode.ts:308:7) at Workflow.runNode (C:\Users\xxx_user\AppData\Roaming\npm\node_modules\n8n\node_modules\n8n-workflow\src\Workflow.ts:1382:8) at C:\Users\xxx_user\AppData\Roaming\npm\node_modules\n8n\node_modules\n8n-core\src\WorkflowExecute.ts:1167:27 at C:\Users\xxx_user\AppData\Roaming\npm\node_modules\n8n\node_modules\n8n-core\src\WorkflowExecute.ts:1887:11

image
image1812×607 112 KB

  • n8n version: 1.62.4
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via : npm
  • Operating system: windown
  • Running pgvector version: docker (pgvector : tag pg 17)
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hi @askasdaf

Thanks for posting here and welcome to the community! :cupcake:

Using schema for specifying tables is not yet supported in PGVector Store node.
The good news is though, we do have a ticket for this in our backlog however :slight_smile:

https://linear.app/n8n/issue/AI-516/community-issue-unable-to-write-data-to-pgvector-with-schema-when

2 Likes
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.