Re: unaccent extension missing some accents

From: J Smith <dark(dot)panda+lists(at)gmail(dot)com>
To: Florian Pflug <fgp(at)phlo(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: unaccent extension missing some accents
Date: 2011-11-07 17:49:51
Message-ID: CADFUPgeJ-XQCUAq=ie_6L9HVH2mntDOeA6Z2oT5=Lh5aSH5N2w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Nov 7, 2011 at 11:53 AM, Florian Pflug <fgp(at)phlo(dot)org> wrote:
>
> Various issues with OSX and UTF-8 locales seems to come up quite often, yet
> we're not really in a position to do anything about them.
>
> Thus, I think we should warn about these issues and save people the trouble
> of finding out about this the hard way. The only question is, what would be
> a good place for such a warning?
>

Hmm, I suppose one place could be on initdb if initializing with a
UTF-8 locale, although that only really helps with fixed settings like
LC_COLLATE and LC_CTYPE and the defaults for the user-configurable
settings, right? For the configurable settings I guess logging as
warnings on server start up or when they're changed via SET. But then
there's all of the other places, like when using COLLATE and using
locale-aware functions and so on and so forth. It would be a lot to
cover, I'll bet.

I guess maybe initdb, start up and SET warnings and a note in the docs
would hopefully suffice?

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-11-07 18:00:34 Re: voting to the xslt_process() need
Previous Message Tom Lane 2011-11-07 17:38:57 Re: unaccent extension missing some accents