Re: Problem in order by - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Problem in order by
Date
Msg-id 20050412065713.H836@megazone.bigpanda.com
Whole thread Raw
In response to Re: Problem in order by  (Reuly Bússolo Mendes <reuly@terra.com.br>)
List 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?


pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Log File Maintainance
Next
From: Tom Lane
Date:
Subject: Re: db restore eats too much memory