Re: BUG #10255: CREATE COLLATION bug on 9.4

From: Emanuel Calvo <emanuel(dot)calvo(at)2ndquadrant(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #10255: CREATE COLLATION bug on 9.4
Date: 2014-05-07 19:55:50
Message-ID: 536A8FC6.3000303@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

El 07/05/14 13:52, Andres Freund escribió:
> On 2014-05-07 12:43:46 -0400, Tom Lane wrote:
>> emanuel(dot)calvo(at)2ndquadrant(dot)com writes:
>>> postgres=# CREATE COLLATION le_english (LC_COLLATE = "UTF8",
>>> LC_CTYPE = "UTF8"); ERROR: could not create locale "UTF8":
>>> Success
>>
>> I get this (on RHEL6):
>>
>> l1=# CREATE COLLATION le_english (LC_COLLATE = "UTF8", LC_CTYPE =
>> "UTF8"); ERROR: could not create locale "UTF8": No such file or
>> directory DETAIL: The operating system could not find any locale
>> data for the locale name "UTF8".
>
> Independent of everything else the 'Success' on Emanuel's suggest
> that errno might not be properly handled...
>

The same command, on 9.3 gives a different error:
ERROR: no se pudo crear la configuración regional «UTF8»: No existe
el fichero o el directorio

(file does not exist)

- --
- --
Emanuel Calvo http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
Bs. As., Argentina (GMT-3)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.18 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIbBAEBCgAGBQJTao/GAAoJEIBeI/HMagHmsOsP+Il/mdpRB7HdiOZSGYmVi3lk
Epp1zQTGWRrPxzsCJ0L9QXhKrYaEcB0AxVMR+czadGmXpWNt26wmuSAAvcU8fKhs
l17BoXIZcYS8HkikypoB90thgLHi/nFkrIWn+zZnD4JVtKnl1XaOK1sW5iojzCLK
pnOaP85aPaFPpicEgD4w7JnqnGJK1IcKd0D1YCLu4emWh8ZchasP4BMHlu7H58Lh
T9RJz/fqQPhFMNeMGM1NbbDw4u4yu6RjxwbCqe4rHqNqge8o1v76MXsqzGLRqhAX
CeEo6o+HrMMQlz9W9xiVr5+Vh98bzn52TdbAKgY6M20wHNAh30o74uHzGKWTAzR5
OA5qbAY2xkqirg4gXNlqBqbjIN+FcU49IvY6zZDmQczfJLAUMc6ByMpH0WaNYt0P
Dj5Lm87lQjESHlPrlsksjSyJy9CIJqBiXNQyvZUmARK1uTHd7I4mj0/W5jcxtwXi
YmjO6uBbjyFJIhwOJAIJS2dIEriYV2Of0FJPGit0AErPF7iogUvIKyi0NbKCBd8F
WbwIdHlbUxcU62/b0oM40Jg8p7IFqat82wzEWE2ofm/vEMlie17cSdCL1PuFUsYz
sHE1zgt85EW5H9yNVJ/Lk9sifYEJey0erkH6pVDMGY9gm8fHdolADlDog9FWYs7J
Q5vR+kCJFS/cMwtL+Ng=
=yzcy
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2014-05-07 20:28:43 Re: BUG #10255: CREATE COLLATION bug on 9.4
Previous Message arnaud.mouronval 2014-05-07 18:17:02 BUG #10256: COUNT(*) behaves sort of like RANK() when used over a window containing an ORDER BY