Re: BUG #10255: CREATE COLLATION bug on 9.4

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

El 07/05/14 17:28, Tom Lane escribió:
> Emanuel Calvo <emanuel(dot)calvo(at)2ndquadrant(dot)com> writes:
>> El 07/05/14 13:52, Andres Freund escribió:
>>> 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
>
> Well, that's what I'd expect. But the relevant code
> (pg_newlocale_from_collation in pg_locale.c) hasn't changed one bit
> since 9.3. And you're not helping any by refusing to divulge what
> OS you're testing on. I'm not in the business of playing guessing
> games, so I think it's your turn to do some work and figure out
> what's different between your 9.3 and 9.4 cases.
>
> regards, tom lane
>

Give me a couple of hours and I will submit a detailed report. :)

Please, don't misunderstood, there is no need to refuse about divulge
the OS version. I found this when doing other work, I wasn't hunting bugs.

root(at)precise64:/opt/deparse# uname -a
Linux precise64 3.2.0-23-generic #36-Ubuntu SMP Tue Apr 10 20:39:51
UTC 2012 x86_64 x86_64 x86_64 GNU/Linux

List of databases
Name | Owner | Encoding | Collate | Ctype | Access
privileges
-
-----------+----------+----------+---------+-------+-----------------------
postgres | postgres | LATIN1 | en_US | en_US |
template0 | postgres | LATIN1 | en_US | en_US | =c/postgres
+
| | | | | postgres=CTc/postgres
template1 | postgres | LATIN1 | en_US | en_US | =c/postgres
+
| | | | | postgres=CTc/postgres
test | postgres | LATIN1 | en_US | en_US |
(4 rows)

root(at)precise64:/opt/deparse# locale
LANG=
LANGUAGE=
LC_CTYPE="en_US"
LC_NUMERIC="en_US"
LC_TIME="en_US"
LC_COLLATE="en_US"
LC_MONETARY="en_US"
LC_MESSAGES="en_US"
LC_PAPER="en_US"
LC_NAME="en_US"
LC_ADDRESS="en_US"
LC_TELEPHONE="en_US"
LC_MEASUREMENT="en_US"
LC_IDENTIFICATION="en_US"
LC_ALL=en_US
root(at)precise64

- --
- --
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/

iQIcBAEBCgAGBQJTarK0AAoJEIBeI/HMagHmibYP/0Rc7M1rC1yi3QLEPIbFbzRh
jwuJUZgy8z1Kdvu96lfyyx1OYgEGZUfv6GfUjtpF8v6Y0WgR9a1cMKPLDV/sVlHA
tP5cheTD7Qkf76T7MEmdJkeTuywAnNbxxXLOhV7j/duJBH7cd2xC6ltA9GTOzqZr
C1W23h1Fuh+1GZwATczXLi86E8ZfY+8w6wwI9kBftUPLKitFKpTqlTvQmx3xWAt2
sl7TH5/ttNJB2E50V1PBdH2tYmFM9Wkr7pKj9k+6OLiLVRqCfNuOm/HOBOcXi0WG
sG+icXqFPchDC/vSMTJsMq1nh1dR/DwGh0iB2qj0kpPVooiZTuEMy2lkcij4FqGy
MKstaE/LMaCATbWLbrtJtCrPtN1SMIm79tuY5tX5qOtAIZL/3+GyEavcV9B3UqvZ
6mCHfJIcO4yy63tlUAV1vt1pP/waDquARXkq93hGsVzugBex48g5Zsb5j5yoYVUT
1RveWg9LO5leLfQWUiINloc+84eF7yphAfkKaDBHfZV6fQf5pYAaectF9BrzDNNH
KDzhQDt+qpYxwkSNsQCHjOQ+oIDKzIyMmS5F/lLQydBiUOF0DxpA0Raf+D6sUwO8
vTOUrSd/9Xijl4bhlFdCTHylqNWSo448ou2hnRTXUfwxHj60qI5rxNjLAxHN7iRW
uje/S5P961fY/q88X+Wn
=U1xe
-----END PGP SIGNATURE-----