Re: why ORDER BY works wrong in pg7.3.4?

From: igor <root(at)osb368(dot)nnov(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: why ORDER BY works wrong in pg7.3.4?
Date: 2003-11-24 09:26:06
Message-ID: 3FC1CEAE.5060200@osb368.nnov.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank u for hint it really helped me - I made initdb with new lc-ctype
and lc-collate
settings : ru_RU:UTF8.
But im still having one question - some functions - lower() and upper()
doesnt work properly . what im doing wrong?

Tom Lane wrote:

> igor <root(at)osb368(dot)nnov(dot)ru> writes:
>
>
>> why "order by" and "like" doesnt work in 7.3.4 properly? - im working
>> with ALT server local settings.
>> in 7.2.xx all this things worked well .
>>
>
>
> Most likely you forgot to select the right locale settings before
> initdb'ing the 7.3 installation. pg_controldata can help you check
> what locale is in force in the database.
>
> regards, tom lane
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Socketd 2003-11-24 10:37:10 The new autovacuum tool
Previous Message igor 2003-11-24 08:59:02 Re: why ORDER BY works wrong in pg7.3.4?