X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3ABD9476317 for ; Thu, 27 Mar 2003 09:49:29 -0500 (EST) Received: from mail.virginia.edu (mail.Virginia.EDU [128.143.2.9]) by postgresql.org (Postfix) with SMTP id 4C17D47630B for ; Thu, 27 Mar 2003 09:49:28 -0500 (EST) Received: from smtp.mail.virginia.edu by mail.virginia.edu id aa14567; 27 Mar 2003 9:49 EST Received: from jlk3xpc (d-128-19-222.bootp.Virginia.EDU [128.143.19.222]) by smtp.mail.Virginia.EDU (8.11.6p/8.11.6) with SMTP id h2REnUh20138; Thu, 27 Mar 2003 09:49:30 -0500 Message-ID: <007001c2f470$f4a936c0$de138f80@virginia.edu> From: Jodi Kanter To: Tom Lane Cc: Postgres SQL List References: <002701c2f3be$880749b0$de138f80@virginia.edu> <9613.1048748250@sss.pgh.pa.us> <004a01c2f46c$61e15d80$de138f80@virginia.edu> <11335.1048775915@sss.pgh.pa.us> Subject: Re: order by Date: Thu, 27 Mar 2003 09:55:49 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Spam-Status: No, hits=-19.1 required=5.0 tests=BAYES_20,ORIGINAL_MESSAGE,QUOTED_EMAIL_TEXT,REFERENCES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/618 X-Sequence-Number: 12656 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" To: "Jodi Kanter" Cc: "Postgres SQL List" Sent: Thursday, March 27, 2003 9:38 AM Subject: Re: [SQL] order by > Jodi Kanter 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 >