Re: order by

I figured out how to run it and it says that LC_COLLATE and LC_CTYPE are
equal to en_US. Can someone please outline the steps to correcting this. I
thought we had done it correctly from initialization but apparently not.

If I need to reinitialize now will that mess with my current databases? Will
I have to shut down production, do a pg_dump and restore?

Other than the sort ordering are there any other problems with NOT having
the environment set to "C?"
Thanks
Jodi

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jodi Kanter" <jkanter(at)virginia(dot)edu>
Cc: "Postgres SQL List" <pgsql-sql(at)postgresql(dot)org>
Sent: Thursday, March 27, 2003 9:38 AM
Subject: Re: [SQL] order by

> Jodi Kanter <jkanter(at)virginia(dot)edu> writes:
> > When we originally initialized I set the LC_COLLATE=C. Was this not
enough?
>
> Should have been ... but see what pg_controldata says about the actual
> setting.
>
> regards, tom lane
>