GUI bulk upsert into nullable unique field gives error - duplicate key value violates unique constraint

Queries and Resources
, ,
1

  • Goal: Hi, I'm trying to bulk upsert external data with the GUI mode in the database resource query interface in the workflow.

  • Issue: A field that's set to both unique and nullable triggered this error "duplicate key value violates unique constraint" because there're many null values.

  • Question: I need to keep those settings for unique constraint and nullable, is there any way to update the database through the UI or SQL?

Write data to SQL databases

2

Hey @evelyn_p,

Apologies for the delay here! Did you already sort this out? As a workaround, does it work if you use a loop block with individual upserts?

Happy to take a look in office hours :slight_smile: