Re: pg_dump error - LOCALIZATION PROBLEM

     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)