On the realistic validation of photometric redshifts