"Alexander Staubo" <alex@purefiction.net> writes:
> why is there no support for changing the database locale after the fact?
It'd corrupt all your indexes (or all the ones on textual columns anyway).
There are some TODO entries related to this, but don't hold your breath
waiting for a fix ...
regards, tom lane