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@sss.pgh.pa.us>
To: "Jodi Kanter" <jkanter@virginia.edu>
Cc: "Postgres SQL List" <pgsql-sql@postgresql.org>
Sent: Thursday, March 27, 2003 9:38 AM
Subject: Re: [SQL] order by


> Jodi Kanter <jkanter@virginia.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
>