Postgres Upsert Node Wiping Existing Data

Hey,

I’m having an issue with the Postgres node, when set to Insert or Update, it should, if the row exists, update any columns you specify whilst leaving any unspecified columns alone, however, this isn’t the case, any unspecified is being set to null. Seems like quite a big bug.

Anyone else?

2 Likes

Hi,

I’m afraid it must be something in your setup, since I cannot replicate this behavior.

I’m on postgresql 16.8
n8n 1.89.2

I tried all kinds of scenarios but couldn’t get it to fail:

  • mapping all fields (default auto-populates all possible): leaving some empty fields, changing only one. works fine
  • mapping all fields (removing some of fields from the list. filling some leaving others empty. works fine.
  • Replacing empty strings with NULL (on / off ) with above scenarios : works fine.

regards,
j.

1 Like

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