We have a workflow that has been working for a while. One of the node is an insert operation into a Postgres table. For some reason, we have to change one of the column from ‘organization’ to ‘organization_code’ in our Postgres db. After the change, we Refresh Column List in the respective node and we can see the renamed column “oraganization_code” and we updated the node accordingly. However when we tried executing the step, we got an error -
record “new” has no field “organization”
Failed query: INSERT INTO $1:name.$2:name($3:name) VALUES($3:csv) RETURNING $4:name
it looks like the node is still trying to execute with the old column name.
To resolve the issue:
- we created a new node to Insert into the same table
- rebooted both n8n and postgres
none of the above help, we are still getting the same error (see screenshot). Any help will be greatly appreciated.
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
Share the output returned by the last node
Information on your n8n setup
- **n8n version: ** version 1.95.2 locally hosted
- **Database (default: SQLite): ** PostgreSQL 14.18
- n8n EXECUTIONS_PROCESS setting (default: own, main): main
- **Running n8n via (Docker, npm, n8n cloud, desktop app): ** docker
- **Operating system: ** ubuntu 22.04