Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 7329063261D for ; Fri, 9 Jan 2009 10:23: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 65656-08 for ; Fri, 9 Jan 2009 10:23:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ey-out-2122.google.com (ey-out-2122.google.com [74.125.78.25]) by mail.postgresql.org (Postfix) with ESMTP id 42B156323D8 for ; Fri, 9 Jan 2009 10:23:38 -0400 (AST) Received: by ey-out-2122.google.com with SMTP id d26so875125eyd.61 for ; Fri, 09 Jan 2009 06:23:36 -0800 (PST) Received: by 10.210.82.7 with SMTP id f7mr12434408ebb.115.1231511015963; Fri, 09 Jan 2009 06:23:35 -0800 (PST) Received: from ?88.195.102.92? ([88.195.102.92]) by mx.google.com with ESMTPS id h6sm77688470nfh.24.2009.01.09.06.23.33 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 09 Jan 2009 06:23:34 -0800 (PST) Message-ID: <49675DE4.9050603@enterprisedb.com> Date: Fri, 09 Jan 2009 16:23:32 +0200 Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.17 (X11/20081018) MIME-Version: 1.0 To: Andrew Dunstan CC: PostgreSQL-development Subject: Re: foreign_data test fails with non-C locale References: <49675B3F.20002@enterprisedb.com> <49675C87.8070303@dunslane.net> In-Reply-To: <49675C87.8070303@dunslane.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit From: Heikki Linnakangas 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/687 X-Sequence-Number: 131331 Andrew Dunstan wrote: > Heikki Linnakangas wrote: >> The foreign_data test case is failing when I run "make installcheck" >> against a server that's been initialized with a locale other than C >> (en_GB.UTF-8). >> >> The reason is the different ordering of upper and lower case >> characters, per attached diff file. We can simply add an alternative >> expected output file, but I'd prefer not to if we can modify the test >> case instead. We could rename some of the object so that they sort the >> same in all locales, but that seems a bit awkward in this case. > > Regression tests have always failed on non-C locales AFAIK. The > buildfarm goes out of its way to avoid that. No, that's the only test case that's failing. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com