Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 80D4363220D for ; Mon, 12 Jan 2009 06:06:41 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 05301-05 for ; Mon, 12 Jan 2009 06:06:38 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mail.postgresql.org (Postfix) with SMTP id 3C95C6321AA for ; Mon, 12 Jan 2009 06:06:38 -0400 (AST) Received: (qmail invoked by alias); 12 Jan 2009 10:06:35 -0000 Received: from unknown (EHLO dhcp-eesp05-101-217.Finland.Sun.COM) [192.18.8.1] by mail.gmx.net (mp009) with SMTP; 12 Jan 2009 11:06:35 +0100 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX18BU7U5RmgBh6s4Ljbf5w4Wd0opkCBRWqryU72vli ELYcDwOCZsAphg Message-ID: <496B161F.9080206@gmx.net> Date: Mon, 12 Jan 2009 12:06:23 +0200 From: Peter Eisentraut User-Agent: Thunderbird 2.0.0.19 (Macintosh/20081209) MIME-Version: 1.0 To: =?UTF-8?B?RGV2cmltIEfDnE5Ew5xa?= CC: Tom Lane , pgsql-hackers@postgresql.org Subject: Re: foreign_data test fails with non-C locale References: <49675B3F.20002@enterprisedb.com> <49676B8A.8020707@dunslane.net> <26314.1231518295@sss.pgh.pa.us> <200901111254.03722.peter_e@gmx.net> <21941.1231692390@sss.pgh.pa.us> <1231704117.3285.15.camel@laptop.gunduz.org> In-Reply-To: <1231704117.3285.15.camel@laptop.gunduz.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Y-GMX-Trusted: 0 X-FuHaFi: 0.64 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/826 X-Sequence-Number: 131470 Devrim GÜNDÜZ wrote: > On Sun, 2009-01-11 at 11:46 -0500, Tom Lane wrote: > >> If we try to fix those cases I think we should try to fix Turkish i >> as well ... but I concur that first requires determining if it's >> behaving wrong or not. Devrim, or someone? > > What exactly do you want to see? Using a glibc system, initdb with --locale=tr_TR (or tr_TR.utf8 or whatever) and run make installcheck. You should see test failures in the tsearch and tsdicts tests that appear to relate to issues with lowercasing the "I" letter correctly. And then use your language skills to determine what the correct behavior is. ;-) Note that on Mac OS X with tr_TR locales, the tests do not fail. I actually suspect that both current answers are wrong.