Greg Stark <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend