PeterDonis said:
I'm not sure this question makes sense as you state it. "Reducing to the flat-space connection" just means covariant derivative = partial derivative when all the connection coefficients are zero. That's a tautology. Once again, the "flat space connection" is not some different connection that the Levi-Civita connection "reduces" to. It's just what you get when all the connection coefficients are zero.
Here's (hopefully) a more precise way of wording my question: if we assert that the connection coefficients must vanish in a locally inertial coordinate system, do we arrive at a unique connection?
I've convinced myself that the answer should be 'yes', but I can't prove it. Here's my attempt at such a proof:
Let ##A## be a vector field, and suppose in a locally inertial coordinate system at event ##p## the components of ##A## are ##A^{\alpha'}##. I define the covariant derivative of ##A## at ##p##, denoted by ##\nabla A(p)##, to be a (1,1) tensor such that in this locally inertial coordinate system its components take the form ##A^{\alpha'}{}_{;\beta'}(p)=\partial_{\beta'}A^{\alpha'}(p)## (##A^{\alpha'}{}_{;\beta'}## being the components of ##\nabla A##, obviously). The only thing left to do is to find the components of ##\nabla A## in a generic coordinate system, which can be done by applying the transformation law for tensors: ##A^\alpha{}_{;\beta}=\frac{\partial x^\alpha}{\partial x^{\alpha'}} \frac{\partial x^{\beta'}}{\partial x^\beta}\partial_{\beta'}A^{\alpha'}##. After some algebra, I found that
A^\alpha{}_{;\beta}=\partial_\beta A^\alpha + \left(-\frac{\partial x^{\alpha'}}{\partial x^\gamma}\partial_\beta \frac{\partial x^\alpha}{\partial x^{\alpha'}} \right) A^\gamma.
If we define ##\Gamma^\alpha_{\beta\gamma}=-\frac{\partial x^{\alpha'}}{\partial x^\gamma}\partial_\beta \frac{\partial x^\alpha}{\partial x^{\alpha'}}##, then it seems like we've found the unique connection that reduces to regular partial derivatives in locally inertial coordinate systems.
My only problem with this proof is that I've been unable to get a formula for ##\Gamma^\alpha_{\beta\gamma}## in terms of the metric and its derivatives, which would allow me to show that we just get the regular Christoffel symbols. I haven't even been able to prove that this connection is torsion free! So I'm doubting my "proof".