Thread: 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
Attachment
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.
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.
Am 24. Mai 2022 16:02:53 MESZ schrieb Tom Lane <tgl@sss.pgh.pa.us>:
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
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