I have a table in Postgres, and I want to insert the data into it.
I have an id column with UUID type in table which default value is “uuid_generate_v4()”. As this is primary key, I am not able to make it nullable. what can I do ?
What is the error message (if any)?
I got this error:
Workflow has issues Add Job Matching Process Item: Column “id” is required
Hi @Ata_Zangene, unfortunately you didn’t share an example workflow so I am not quite sure how exactly you have set up your Postgres node.
However, based on the available information I assume you are using the Insert operation on the Postgres node. Perhaps you might want to switch to the Execute Query operation instead? This way you can write a custom INSERT statement account for your table schema rather than having to rely on n8n’s built-in logic to get everything right.