Hi, I wonder if there is a way to add more then one ON CONSTRAINT value. I have many different unique constraints on my table and I would like to catch and handle two of them with ON CONFLICT ON CONSTRAINT. And the rest errors will be handled by the client application.
INSERT INTO table_1 (id, name, value, user_id, description) VALUES (1, 'name', 'value', null, null) ON CONFLICT ON CONSTRAINT *table1_pkey, table1_name_key* DO UPDATE SET value = EXCLUDED.value, user_id = EXCLUDED.user_id, description = EXCLUDED.description Regards, Arnold