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.
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