Peter Eisentraut wrote:
> Allan Engelhardt writes:
>
> > I find locale support in PostgreSQL confusing. The locale of the
> > current user at the time of initialising the database determines the
> > collating order (e.g. is 'a' < 'A'). This in turns affect things like
> > indexing (as described below).
>
> This is because if you were allowed to change this setting after the
> database initialization, your indexes would get corrupted. (Recall that
> (some) indexes are sorted, and the index scanning code relies on indexes
> being sorted a certain way.)
Yes, I understand WHY it is, I just wish it was documented somewhere obvious. But nevermind - that what these mailing
listsare for!
Thanks, all.
Allan.