Re: Problems with pgsql 8.0.4 & freebsd 6: partially solved - Mailing list pgsql-general

From Tom Lane
Subject Re: Problems with pgsql 8.0.4 & freebsd 6: partially solved
Date
Msg-id 18699.1138116255@sss.pgh.pa.us
Whole thread Raw
In response to Problems with pgsql 8.0.4 & freebsd 6: partially solved  (Vittorio <vdemart1@tin.it>)
List pgsql-general
Vittorio <vdemart1@tin.it> writes:
> FATAL:  XX000: failed to initialize lc_messages to ""
> LOCATION:  InitializeGUCOptions, guc.c:3699

We've seen that reported before, on more than one platform (I recall
hearing about it on OS X, for instance).  But no one's ever been able
to explain what causes it.  It's interesting to hear that a full
database reinstall made it go away for you, but that was certainly
overkill.  Do you have the time to experiment with the locale settings
and see if you can identify the difference between the cases where it
happens and those where it doesn't?

> After many attempts I discovered that the problem was connected to the
> "setenv LC_ALL it_IT.ISO_8859-1" I had introduced in /usr/local/pgsql/.cshrc

Do you have any other LC_xxx variables set?  How about LANG?  Is that
string still a valid locale name on your updated platform?

            regards, tom lane

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: Does this look ethical to you?
Next
From: "Dave Page"
Date:
Subject: Re: Does this look ethical to you?