How do I use the

onConflict

option when doing a mass insert? What syntax do I need to use? I have a composite unique constraint that consists of two columns. I'm periodically inserting the whole data set and want to just ignore the row if it already exists (or maybe update the

updated_at

column). One tutorial I found suggested the following:

ON CONFLICT ON CONSTRAINT customers_name_key 
DO NOTHING

So how would I write that with the supabase JS library?

The

ignoreDuplicates

option on upsert does

DO NOTHING

, see: https://supabase.com/docs/reference/javascript/upsert

Thanks, I need to try if that works with insert. I think I can't use upsert since I don't have the primary ID