Re: Collation rules and multi-lingual databases - Mailing list pgsql-general

From Tom Lane
Subject Re: Collation rules and multi-lingual databases
Date
Msg-id 20363.1061414727@sss.pgh.pa.us
Whole thread Raw
In response to Collation rules and multi-lingual databases  (Greg Stark <gsstark@mit.edu>)
Responses Re: Collation rules and multi-lingual databases  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> My understanding is that the entire set of localization parameters needs to be
> decided upon when the initdb is done and can never be changed later. Is that
> right?

No, not all of them are frozen.  Unfortunately, the one you care about
(LC_COLLATE) is.  The reason for this is that it determines index
ordering for textual columns, and so changing LC_COLLATE on the fly
produces instant corrupt indexes :-(

A solution for this is on the TODO list, but don't hold your breath ...

            regards, tom lane

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Buglist
Next
From: Francois Suter
Date:
Subject: Re: Mailing list in French