Children had to be evacuated from a day-care centre when a gunman walked into a US cathedral and opened fire.