Обсуждение: Error setting lc_time

Hi database experts,

When trying to set the lc_time parameter, an error occurs:

     ERROR:  invalid value for parameter "lc_time": "uk_UA.UTF-8"

The locale is set up in the operating system:

     $ locale -a | grep ^uk
     uk_UA.utf8

What do I have to do to introduce all locales of the operating system to 
PostgreSQL?

Several other lc_time settings work (with or without - between UTF and 
8, utf spelled in upper or lower case).

Regards,

Holger

-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

Holger Jakobs <holger@jakobs.com> writes:
> When trying to set the lc_time parameter, an error occurs:
>      ERROR:  invalid value for parameter "lc_time": "uk_UA.UTF-8"

Works for me ...

regression=# set lc_time = 'uk_UA.UTF-8';
SET

Maybe this setting is inconsistent with the rest of your LC_xxx
parameters (particularly lc_collate, lc_ctype)?

> What do I have to do to introduce all locales of the operating system to 
> PostgreSQL?

With zero context provided, it's hard to make any useful suggestions.
But this looks like an OS question not a Postgres question.

            regards, tom lane

I had not restarted PostgreSQL after introducing further locales.

My error.

It seems that PostgreSQL reads the list of locales when starting up.

Regards,
Holger

Sorry für top Posting, this is all my mail app allows.

Holger Jakobs <holger@jakobs.com> writes:
> I had not restarted PostgreSQL after introducing further locales.
> My error.

> It seems that PostgreSQL reads the list of locales when starting up.

Postgres does no such thing; it has no use for a list of locales.
It's possible something inside libc does, though.

            regards, tom lane