How erratic can a politician act in public before getting in trouble?

It's not specifically how crazy, but when and where it surfaces. Just ask anyone why Howard Dean isn't the President.