The following bug has been logged on the website:
Bug reference: 10255
Logged by: Emanuel
Email address: emanuel.calvo@2ndquadrant.com
PostgreSQL version: Unsupported/Unknown
Operating system: Non related
Description:
When trying to create COLLATIONS, I'm facing some issues:
--- BUG REPORT
postgres=# CREATE COLLATION le_english (LOCALE = "en_US.utf8");
ERROR: encoding "LATIN1" does not match locale "en_US.utf8"
DETAIL: The chosen LC_CTYPE setting requires encoding "UTF8".
Ok, it requires LC_CTYPE. Added it, but:
postgres=# CREATE COLLATION le_english (LOCALE = "en_US.utf8", LC_CTYPE =
"UTF8");
ERROR: conflicting or redundant options
Oh, wait a minute. Something 's wrong with the locale.
Rewritten with LC_COLLATE:
postgres=# CREATE COLLATION le_english (LC_COLLATE = "UTF8", LC_CTYPE =
"UTF8");
ERROR: could not create locale "UTF8": Success
This bug was found on 9.4dev.