When creating a row in the Postgres table via the Postgres node, if, for example, the id column has the primary property, then it is impossible to create a row with manual mapping.
This is due to the fact that the table automatically numbers the id column, respectively, with manual mapping, you do not need to transfer data to the id, and n8n forcibly asks you to fill in the data.
If you copy and paste the node into notepad, then remove the obligation of the id field and move the node back into the process, then n8n allows you to delete the id field, after which the entry in the database goes well.
I don’t think this is a good solution, I think it should be possible to delete a field with the primary property during manual mapping.
How does your table automatically serialize the id column?
I just tested (on newest node version 2.5) and it does recognize when a column is not required for the insert statement.
See in my screenshot, the id column is not required because my primary key has a default value defined by the nextval() expression.
