Re: BUG #10255: CREATE COLLATION bug on 9.4 - Mailing list pgsql-bugs

From Emanuel Calvo
Subject Re: BUG #10255: CREATE COLLATION bug on 9.4
Date
Msg-id 536AB2B5.9080806@2ndquadrant.com
Whole thread Raw
In response to Re: BUG #10255: CREATE COLLATION bug on 9.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512



El 07/05/14 17:28, Tom Lane escribió:
> Emanuel Calvo <emanuel.calvo@2ndquadrant.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@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@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@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-----

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #10254: Joined Constraints not invoked on date ranges
Next
From: David G Johnston
Date:
Subject: Re: BUG #10256: COUNT(*) behaves sort of like RANK() when used over a window containing an ORDER BY