Norfolk's city jail psychiatrist has resigned amid ‘out of control’ prescription drug abuse from jail-issued medications.