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

From Tom Lane
Subject Re: How TODO prevent PQfnumber() from lowercasing?
Date
Msg-id 5088.1129158361@sss.pgh.pa.us
Whole thread Raw
In response to Re: How TODO prevent PQfnumber() from lowercasing?  (Volkan YAZICI <volkan.yazici@gmail.com>)
Responses Re: How TODO prevent PQfnumber() from lowercasing?
Re: How TODO prevent PQfnumber() from lowercasing?
List pgsql-hackers
Volkan YAZICI <volkan.yazici@gmail.com> writes:
> 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?

Really, PQfnumber shouldn't do any case folding at all; that's not in
its charter if you ask me.  The problem is how to get there from here
without too much compatibility pain.  Maybe invent a new routine that
does it right and then deprecate the existing one?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: How TODO prevent PQfnumber() from lowercasing?
Next
From: Tom Lane
Date:
Subject: Re: Comments on columns in the pg_catalog tables/views