The principal of a school in Songkhla province has resigned after pulling out a gun in morning assembly last week and in response to allegations of having a sexual relationship with one of his students.