Sort in PostgreSQL

From: Mauricio de Castro <mcastro(at)univates(dot)br>
To: PGSQL <pgsql-admin(at)postgresql(dot)org>
Subject: Sort in PostgreSQL
Date: 2001-04-26 11:09:17
Message-ID: 3AE801DD.50F7D5A1@univates.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Luis Sousa 2001-04-26 13:38:42 Users logged !
Previous Message Tom Lane 2001-04-26 05:18:59 Re: createdb failing