hi,
I have also seen the same problem. But there is another problem related
with locale.
The function MIN is translated into mýn ( in Turkish locale support) and
postgres gives an
error message as follows:
Function 'mýn(int8)' does not exist .
But when I use "LIKE" , postgres does the operations correctly. I don't
know the internals of postgres,
but I want to solve this problem somehow?
Thanks in advance.
Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > Untested, but try this:
>
> > Edit src/backend/commands/variable.c, look for the function
> > parse_XactIsoLevel(). Change the code that looks like this:
>
> > if (strcasecmp(value, "SERIALIZABLE") == 0)
> > XactIsoLevel = XACT_SERIALIZABLE;
> > else if (strcasecmp(value, "COMMITTED") == 0)
> > XactIsoLevel = XACT_READ_COMMITTED;
>
> > into:
>
> > if (strcmp(value, "serializable") == 0)
> > XactIsoLevel = XACT_SERIALIZABLE;
> > else if (strcmp(value, "committed") == 0)
> > XactIsoLevel = XACT_READ_COMMITTED;
>
> Hmm. Given that we expect the lexer to have downcased any unquoted
> words, this seems like a workable solution --- where else are we using
> strcasecmp() unnecessarily?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)