There are some other threads about this in the OpenACS 4.x design
forum (try searching for "lang" and "collating" and "tree" or
something like that).
Out of the box OpenACS 4 works with LANG=C. Among other things if
LANG != C then Postgres won't use indexes for "LIKE 'foo%'"-style
operators, which implies a horrible efficiency hit for any
hierarchical select using the sortkeys.
So, check the other threads on the issue, you'll find a fairly
complete discussion. We don't have a solution that's satisfactory
for the case where LANG != C yet.