Re: How TODO prevent PQfnumber() from lowercasing? - Mailing list pgsql-hackers

From Volkan YAZICI
Subject Re: How TODO prevent PQfnumber() from lowercasing?
Date
Msg-id 7104a7370510121157i5bf8ebaay8f168a51cec5fe74@mail.gmail.com
Whole thread Raw
In response to Re: How TODO prevent PQfnumber() from lowercasing?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: How TODO prevent PQfnumber() from lowercasing?
Re: How TODO prevent PQfnumber() from lowercasing?
List pgsql-hackers
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?


pgsql-hackers by date:

Previous
From: Eric Sproul
Date:
Subject: Re: 8.1 beta1 -> beta2 upgrade question
Next
From: Tom Lane
Date:
Subject: Re: 8.1 beta1 -> beta2 upgrade question