Re: Per-column collation, proof of concept

On Wed, Aug 18, 2010 at 11:29 AM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> On tis, 2010-08-17 at 01:16 -0500, Jaime Casanova wrote:
>> >> creating collations ...FATAL:  invalid byte sequence for encoding
>> >> "UTF8": 0xe56c09
>> >> CONTEXT:  COPY tmp_pg_collation, line 86
>> >> STATEMENT:  COPY tmp_pg_collation FROM
>> >> E'/usr/local/pgsql/9.1/share/locales.txt';
>> >> """
>> >
>> > Hmm, what is in that file on that line?
>> >
>> >
>>
>> bokmål  ISO-8859-1
>
> Hey, that borders on genius: Use a non-ASCII letter in the name of a
> locale whose purpose it is to configure how non-ASCII letters are
> interpreted. :-/
>
> Interestingly, I don't see this on a Debian system.  Good thing to know
> that this needs separate testing on different Linux variants.
>
>

Yeah! and when installing centos 5 i don't have a chance to choose
what locales i want, it just installs all of them

--
Jaime Casanova         www.2ndQuadrant.com
Soporte y capacitación de PostgreSQL