Re: How TODO prevent PQfnumber() from lowercasing?

From: Volkan YAZICI <volkan(dot)yazici(at)gmail(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: How TODO prevent PQfnumber() from lowercasing?
Date: 2005-10-12 18:57:20
Message-ID: 7104a7370510121157i5bf8ebaay8f168a51cec5fe74@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 10/12/05, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Emil Briggs 2005-10-12 19:07:23 Re: Spinlocks, yet again: analysis and proposed patches
Previous Message Alvaro Herrera 2005-10-12 18:27:47 Re: 8.1 beta1 -> beta2 upgrade question