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