Re: pg_dump error - LOCALIZATION PROBLEM - Mailing list pgsql-general

From Burak Bilen
Subject Re: pg_dump error - LOCALIZATION PROBLEM
Date
Msg-id 3BA5C9D2.6E07796E@metu.edu.tr
Whole thread Raw
In response to Re: pg_dump error - LOCALIZATION PROBLEM  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
     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)


pgsql-general by date:

Previous
From: Hans-Juergen Schoenig
Date:
Subject: strange core dump ...
Next
From: Ken Conrad
Date:
Subject: Characters displaying as x2F