Re: Collation Order Change

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Len Morgan" <len-morgan(at)crcom(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Collation Order Change
Date: 2002-05-22 14:20:19
Message-ID: 23964.1022077219@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Len Morgan" <len-morgan(at)crcom(dot)net> writes:
> The problem shows up in names that contain more than one word. It seems
> that the "new" alphabetical order doesn't look at spaces or dashes when
> deciding on order. For example:

Sounds like you have selected a non-C locale (most likely en_US, which
is the system default in recent RH releases). Unfortunately the only
way to change PG's locale is a fresh initdb :-(. Try

export LANG=C
locale --- make sure it says "C" for everything
initdb

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-05-22 15:44:40 Re: .doc .rtf database in PostgreSQL+PHP
Previous Message lee johnson 2002-05-22 14:19:53 no pg_hba.conf