Re: Per-column collation

On mån, 2010-12-06 at 21:26 +0200, Peter Eisentraut wrote:
>
> > * contrib/citext raises an encoding error when COLLATE is specified
> > even if it is the collation as same as the database default.
> > We might need some special treatment for C locale.
> > =# SHOW lc_collate; ==> C
> > =# SELECT ('Ａ'::citext) = ('ａ'::citext); ==> false
> > =# SELECT ('Ａ'::citext) = ('ａ'::citext) COLLATE "C";
> > ERROR: invalid multibyte character for locale
> > HINT: The server's LC_CTYPE locale is probably incompatible with
> the
> > database encoding.
>
> OK, I can reproduce that. That's fallout from the lc_ctype_is_c()
> optimization that I removed, as explained in another email. I'll have
> to think about that again.

This is fixed in the 20101213 patch I'm about to send out.