Re: BUG #1583: Locale problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew Grillet" <andrew(at)grillet(dot)co(dot)uk>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1583: Locale problem
Date: 2005-04-05 20:31:55
Message-ID: 2338.1112733115@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Andrew Grillet" <andrew(at)grillet(dot)co(dot)uk> writes:
> error message XX000: cannot assign "" to LC_messages - or something like
> this.

We've seen this before but AFAIR no one has ever really satisfactorily
explained what's happening. Assigning an empty string *should* work;
the definition of setlocale is that it's supposed to select the default
locale. It's difficult to believe that selecting the default locale
does not work.

If you check the archives you will definitely find this mentioned in
connection with Mac OS X. Not sure if we've heard it before for FreeBSD
or not. What FreeBSD release have you got exactly, and what locale
environment were you starting the postmaster in? Did you have
nondefault values for any of the other LC_xxx settings?

> (I dont really want locale support
> anyway, I just want European dates.)

In that case you should stick with C locale and just set DateStyle.
But if you'd like to help track down this locale failure first ...

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Benjamin Reed 2005-04-06 18:01:53 BUG #1584: undefined symbol _tas
Previous Message Andrew Grillet 2005-04-05 20:13:07 BUG #1583: Locale problem