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.