I just tested that and the trigger causes the INSERT to return no rows if the row already exists. It basically turns the ON CONFLICT DO UPDATE into ON CONFLICT

I just tested that and the trigger causes the INSERT to return no rows if the row already exists. It basically turns the ON CONFLICT DO UPDATE into ON CONFLICT DO NOTHING.