"Paul Simpson" <Paul(dot)Simpson(at)spgs(dot)org> writes:
> I accept the back-end converts them. What I'm saying is could I not re-comp
> ile the back-end to make it convert to upper case instead?
If that were a simple change, somebody would have done it before you.
(Hint: the problem is not in changing a few lines in the lexer, it's in
fixing everything else that will break.)
What might be easier is to hack the ODBC driver so that those
system-catalog queries it issues are case-insensitive --- for instance,
use "ilike" in place of "like". I am not certain that would fix your
problem completely, but it'd be worth trying.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Paul Simpson||Date: 2004-02-25 14:58:23|
|Subject: Re: Why does app fail?|
|Previous:||From: Karam Chand||Date: 2004-02-25 14:57:04|
|Subject: Moving from MySQL to PGSQL....some questions|