Re: Change collate postgresql
От
marcelo mendoza
Тема
Re: Change collate postgresql
Дата
Msg-id
CAPSkOeVgP=z2Cxsv-qpLMgF26X5DzcFHaWwjKMVJqTVwLBW-Ww@mail.gmail.com
Ответ на
Re: Change collate postgresql (Tom Lane)
Список
Дерево обсуждения
Change collate postgresql marcelo mendoza <jmarcelo.mendoza@gmail.com>
Re: Change collate postgresql Laurenz Albe <laurenz.albe@cybertec.at>
Re: Change collate postgresql marcelo mendoza <jmarcelo.mendoza@gmail.com>
Re: Change collate postgresql Tom Lane <tgl@sss.pgh.pa.us>
Re: Change collate postgresql marcelo mendoza <jmarcelo.mendoza@gmail.com>
In any case, could it be left like this or is the recommendation to perform the update?
Regards
El mié., 19 ago. 2020 a las 9:56, Tom Lane (<tgl@sss.pgh.pa.us>) escribió:
marcelo mendoza <jmarcelo.mendoza@gmail.com> writes:
> Hi Laurenz, this is the space en_US.UTF- 8 (the space is before the 8)
> Collate | en_US.UTF-
> | 8
> The database was created in this way, without error, how can I fix this?
I'm guessing that you specified LC_COLLATE that way when you created
the database. Postgres won't complain if setlocale() doesn't, which
it very possibly wouldn't.
I don't believe we offer any DDL command to change that, so a direct
UPDATE on pg_database is the only way. Should be pretty harmless
as long as you don't try to change the setting to a functionally
different value.
regards, tom lane
Marcelo Mendoza
(0983) 383-752
В списке pgsql-novice по дате отправления
