pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedError setting lc_time
4+ messages / 2 participants
[nested] [flat]
* Error setting lc_time
@ 2022-05-24 12:24 Holger Jakobs <holger@jakobs.com>
0 siblings, 1 reply; 4+ messages in thread
From: Holger Jakobs @ 2022-05-24 12:24 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Error setting lc_time
@ 2022-05-24 14:02 Tom Lane <tgl@sss.pgh.pa.us>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2022-05-24 14:02 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Error setting lc_time
@ 2022-05-24 14:31 Holger Jakobs <holger@jakobs.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Holger Jakobs @ 2022-05-24 14:31 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Error setting lc_time
@ 2022-05-24 14:44 Tom Lane <tgl@sss.pgh.pa.us>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2022-05-24 14:44 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-05-24 14:44 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-05-24 12:24 Error setting lc_time Holger Jakobs <holger@jakobs.com>
2022-05-24 14:02 ` Tom Lane <tgl@sss.pgh.pa.us>
2022-05-24 14:31 ` Holger Jakobs <holger@jakobs.com>
2022-05-24 14:44 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox