X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4AFF08B9E67 for ; Tue, 1 Feb 2005 12:49:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68882-06 for ; Tue, 1 Feb 2005 12:48:56 +0000 (GMT) Received: from web41006.mail.yahoo.com (web41006.mail.yahoo.com [66.218.93.5]) by svr1.postgresql.org (Postfix) with SMTP id 686948B9CF3 for ; Tue, 1 Feb 2005 12:48:58 +0000 (GMT) Received: (qmail 38442 invoked by uid 60001); 1 Feb 2005 12:48:58 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=0QKh7J2BshI0jHu6v5eGL5b1MbhnaIWgouRlkwHhYe7FVLwWzaiOflcZ9IQND6WmqcqwaL4KLpIesz4GB0I018OfNbN1SOGBFkRZT/Zmh/mg9f5NcyeJg/eX1boNXKswmIgNrFXXJbha5/QSJ1FVN85+yslpPgM1OcYDpTlkUa8= ; Message-ID: <20050201124858.38440.qmail@web41006.mail.yahoo.com> Received: from [66.108.25.20] by web41006.mail.yahoo.com via HTTP; Tue, 01 Feb 2005 04:48:57 PST Date: Tue, 1 Feb 2005 04:48:57 -0800 (PST) From: Theodore Petrosky Subject: Re: case sensitive/insensitive confusion To: pgsql-sql@postgresql.org In-Reply-To: <200502011114.00969.peter_e@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.249 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200502/22 X-Sequence-Number: 20133 I seem to have a problem with controlling the locale. Mac os x, postgresql 8.0.1 ./configure --with-rendezvous --enable-thread-safety --enable-locale but when I try: initdb --locale=es_ES ~/testdb I get: The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale es_ES. initdb: could not find suitable encoding for locale "es_ES" Rerun initdb with the -E option. Try "initdb --help" for more information. Am I missing something in OS X, or is this a postgresql issue, or a combination? I even tried initdb --locale=en_US ~/testdb and I still get the same error.... I am actually looking based on a conversation with someone in Portugal that can not figure it out and he needs it. Any help to pointers would be great... Ted --- Peter Eisentraut wrote: > Christoph Haller wrote: > > It seems to me under hpux the sort is done case > sensitive, > > as would one expect on SQL_ASCII encoding, whereas > > under linux a case insensitive sort is done. > > The sort order depends entirely on the locale that > you specify to initdb > (not the encoding). Please check the documentation > there. > > -- > Peter Eisentraut > http://developer.postgresql.org/~petere/ > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose > an index scan if your > joining column's datatypes do not match > __________________________________ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo