Thread: Sort in PostgreSQL

Sort in PostgreSQL

From
Mauricio de Castro
Date:
    Hello, I am with a problem in the SAGU
(http://sagu.codigoaberto.org.br), more specifically in the Postgres (we
use version 6.5.3) with the sort of names.
    It separates capital and lowcase letters and letters with and without
accents.
    After one he searches, we find that we would have to make right the
following variables:
    LC_CTYPE=C - > ISO-8859-1
    LC_COLLATE=C - > ISO-8859-1
    and to restart the process of the postmaster. It functioned in part, in
a Debian server (Storm) it was the sufficient to start to function, in
the server of the SAGU, a Slackware 7.1 machine, this did not function.
    More research and we evidence that we would have to recompile the
Postgres with the following options:
  ./configure -- enable-locale -- enable-recode,
    thing that we had not done...  and nothing...  We install one script to
make right the pattern keyboard.  And nothing...  We leave of the
Windows and we enter of new... I'm play because I use Linux...  Somebody
has some idea of that to make to decide our problem?

Regards

Mauricio de Castro
Meneger and Development of SAGU

Re: Sort in PostgreSQL

From
Peter Eisentraut
Date:
Mauricio de Castro writes:

>     After one he searches, we find that we would have to make right the
> following variables:
>     LC_CTYPE=C - > ISO-8859-1
>     LC_COLLATE=C - > ISO-8859-1
>     and to restart the process of the postmaster.

You also have to re-initdb your database cluster (with those variables
set).  Might as well update to 7.1 while you're at it.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter