Re: ltree installation error

Hi Tom,
I'm releaved now. the problem is solved
You're right. the problem was locales not installed.
I just ran "dpkg-reconfigure locales" and install the repsectives.


btw, I'm turned into a pgsql fan.
i just posted  a thread at pgsql-sql
http://archives.postgresql.org/pgsql-sql/2007-12/index.php



thanks a lot,
iuri

On Dec 19, 2007 5:23 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Iuri Sampaio" <iuri.sampaio@gmail.com> writes:
> > I don;t understand how it's related with postgresql installation. I
> never
> > had this problem before.
> > My locale is set:
>
> > debian:~# locale -a
> > C
> > en_US.utf8
> > POSIX
>
> Well, your original report was about this:
>
> FATAL:  invalid value for parameter "lc_messages": "en_CA.UTF-8"
>
> which evidently is not a locale that your system has got.  The
> locale -a printout suggests that if it is there, it'd be named
> "en_CA.utf8", and it's hard to tell whether your platform would
> be forgiving of the spelling difference or not.  In any case,
> the question is where Postgres got that setting from.  AFAIK
> the only likely explanation is that LANG was set that way when
> you ran initdb.
>
> You could try modifying lc_messages in postgresql.conf, but it
> might be safer to wipe the database directory and re-initdb
> with a corrected LANG setting.
>
>                        regards, tom lane
>