BUG #10255: CREATE COLLATION bug on 9.4

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.