Column id violates not-null constraint yet there is an ID column? Postgres PGVectorstore

Questions
1

Describe the problem/error/question

When attempting to insert data into my postgres vector store I get “Error inserting: null value in column”id” of relation “ot_notes” violates not null constraint.

I can see in the table view that I have column “id” and that all of the items have a value in them.

I have attempted to drag the column into the field as an expression but still get the same error. I doublechecked that the column name in my table is identical as well.

image
image1647×748 82.3 KB

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

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

Hello @ArcReactorKC

Based on your screenshot, the column name is id in the input section. So in the Parameters settings for ID Column Name, expression should be {{ $json.id }}

3

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