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 14:42:22
Message-ID: 20050412073944.V2526@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

> The command's return
> teste=# show LC_COLLATE;
> ERROR: Option 'lc_collate' is not recognized

Darn, that must have been added after 7.3.x. If you have pg_controldata,
I think you can use pg_controldata <path to data directory>. I don't
remember enough about 7.3 at this point to know for certain.

> I remade the process of yesterday (dropdb and move directory) and added in
> initdb the option --lc_collate=C without taking off -- locale=C, executed
> but it does not appear in postgresql.conf and the problem continues.

You are doing that with the server stopped, correct?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2005-04-12 14:43:23 Re: Problem in order by
Previous Message Marcin Giedz 2005-04-12 14:41:36 pg_temp_xxx schemas