Postgres insert or update not working when id is 0

Questions
1

I have this data:

[
  {
    "id": 0,
    "name": "Osobiście/tel.",
    "group": "personal"
  }
]

I can use “insert” or “update” action in postgress, but when I try to use “insert or update” action, I get an error: Column to match on not found in input item.

Information on your n8n setup

  • **n8n version:**1.22.6
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

Hey @Valdri,

That is very odd, I will get a ticket created for it shortly so we can fix it. How often do you have an id of 0, This is the first time I have heard of someone using 0 as an id value so it would be handy to get an idea of how much of an issue this might be.

4

Hi @Jon,
baselinker most popular ERP in Poland, uses 0 as identifier in api getOrderSources request.
To fix this issue, I use a custom SQL query