X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6CE3BD1B502 for ; Wed, 17 Sep 2003 14:07:16 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 20514-01 for ; Wed, 17 Sep 2003 11:07:06 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id BF207D1B50F for ; Wed, 17 Sep 2003 11:07:02 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h8HE6wpr001936; Wed, 17 Sep 2003 10:06:58 -0400 (EDT) To: =?ISO-8859-1?Q?Kristian_J=F6rg?= Cc: Richard Huxton , pgsql-sql@postgresql.org Subject: Re: Sort order with spaces? In-reply-to: <3F6853E4.3000604@devo.se> References: <3F682DB3.6080905@devo.se> <200309171144.02871.dev@archonet.com> <3F6853E4.3000604@devo.se> Comments: In-reply-to =?ISO-8859-1?Q?Kristian_J=F6rg?= message dated "Wed, 17 Sep 2003 14:30:28 +0200" Date: Wed, 17 Sep 2003 10:06:58 -0400 Message-ID: <1935.1063807618@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/158 X-Sequence-Number: 15136 =?ISO-8859-1?Q?Kristian_J=F6rg?= writes: > Unfortunately this does not seem to help! I dumped the database, > recreated the cluster with initdb with LC_COLLATE = C (and even tried > setting LC_CTYPE to C also), and restored the database. The same > ordering appears... You didn't do it right then ... 7.2's initdb is not helpful about telling you exactly what locale settings it's using, but you could use the contrib/pg_controldata utility to check what LC_COLLATE and LC_CTYPE settings got used. (If you don't want to build pg_controldata, "strings $PGDATA/global/pg_control" will do as a rough-and-ready substitute.) Theoretically it should work to do export LC_COLLATE=C export LC_CTYPE=C initdb but if you have LANG or other LC_xxx values in your environment, it's possible that there is some conflict. regards, tom lane