A gunman went on the rampage in the US, killing a policeman and one other man before turning the gun on himself in a church.