Mihail Marinov writes:
> My problem is that ORDER BY does not alphabetically order strings in
> proper way. Worst - it does sometimes work right but I can't find out
> exactly why. But after a while it stops until I rebuild and
> reconfigure.
You must have the same collation locale setting (LC_COLLATE, or LC_ALL as
default) when running initdb and when running postmaster. Changing the
setting in between will result in random and incorrect results and
database corruption.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/