The South African detective, pulled off the investigation of athletics star Oscar Pistorius for murder after it emerged he himself faces attempted murder charges, has resigned from the force, police said on Thursday.