On 10/12/05, Bruce Momjian <pgman@candle.pha.pa.us> wrote: > The question mark means we are not sure how to deal with it. I think > your idea of using quotes to preserve case is a good one.
I think related TODO is added for that gotcha which was written in PQfnumber() comments in fe-exec.c: «Downcasing in the frontend might follow different locale rules than downcasing in the backend.» Returned column names from the backend were lowercased by the server in this or that way. Furthermore, PQfnumber() makes not-quoted strings downcasing on the client side and then performs the compare by using the results returned from the backend. To sum up, at the moment I couldn't see any possible solution for this TODO. (I'll be appreciated to hear your suggestions on the case.) An un-fixable situation? ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster