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