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