X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4086B528D0 for ; Thu, 30 Jun 2005 10:57:33 -0300 (ADT) 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 36607-02 for ; Thu, 30 Jun 2005 13:57:30 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8002F52801 for ; Thu, 30 Jun 2005 10:57:29 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j5UDvYfs018358; Thu, 30 Jun 2005 09:57:34 -0400 (EDT) To: Hannes Dorbath Cc: pgsql-admin@postgresql.org Subject: Re: unicode In-reply-to: <42c3cee1$0$22365$8fe63b2a@news.disputo.net> References: <42bbcec1$0$5607$8fe63b2a@news.disputo.net> <200506241655.56840.peter_e@gmx.net> <42c3ba5e$0$22388$8fe63b2a@news.disputo.net> <200506301254.07283.peter_e@gmx.net> <42c3cee1$0$22365$8fe63b2a@news.disputo.net> Comments: In-reply-to Hannes Dorbath message dated "Thu, 30 Jun 2005 13:26:11 +0200" Date: Thu, 30 Jun 2005 09:57:33 -0400 Message-ID: <18357.1120139853@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/289 X-Sequence-Number: 18044 Hannes Dorbath writes: >> I hear that FreeBSD doesn't support Unicode, so you're probably out of luck >> for now. > Hm, but the locales are there, it's just named de_DE.UTF-8 instead of > de_DE.utf8 on FreeBSD. InitDB crashs with the following: > creating template1 database in /opt/pgsql/data/base/1 ... FATAL: XX000: > failed to initialize lc_messages to "" > LOCATION: InitializeGUCOptions, guc.c:2389 We've seen that happen before. As far as I can see it indicates breakage in the locale library: setlocale(LC_MESSAGES, "") should work, but it's failing. I'm not certain this is the total story, since the same failure has been seen on several platforms and it's hard to believe they are all brain-damaged. But I don't really see what we should do differently. regards, tom lane