BUG #10255: CREATE COLLATION bug on 9.4

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.

Responses

Browse pgsql-bugs by date

  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