Re: Problem in order by

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Reuly Bússolo Mendes <reuly(at)terra(dot)com(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problem in order by
Date: 2005-04-12 13:58:53
Message-ID: 20050412065713.H836@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, 11 Apr 2005, [iso-8859-1] Reuly Bússolo Mendes wrote:

> Hi Stephan, tks
>
> I drop database and move directory data to data01.
> I already executed "initdb --locale=C" and the file postgresql.conf change
> to LC_MESSAGES, LC_MONETARY, LC_NUMERIC and LC_TIME = 'C', but the problem
> persist.

I think LC_COLLATE would be the one that is the issue, but --locale=C
should have done it I think. To be sure, what does "show LC_COLLATE;"
give on the database that has the problem?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-04-12 14:09:01 Re: db restore eats too much memory
Previous Message Scott Marlowe 2005-04-12 13:51:56 Re: Log File Maintainance