Seething US president made barrage of threats against America's northern neighbour in a social media tirade