On completeness of Halphen systems and of pseudo-Riemannian geodesic flows