From: | emanuel(dot)calvo(at)2ndquadrant(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #10255: CREATE COLLATION bug on 9.4 |
Date: | 2014-05-07 15:59:18 |
Message-ID: | 20140507155918.1397.98656@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 10255
Logged by: Emanuel
Email address: emanuel(dot)calvo(at)2ndquadrant(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-05-07 16:11:41 | Re: Server process crash - Segmentation fault |
Previous Message | Leif Jensen | 2014-05-07 15:46:40 | Re: Server process crash - Segmentation fault |