From: Tom Lane <tgl@sss.pgh.pa.us>
To: emre@hasegeli.com
cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>,
        tomasz.kontusz@gmail.com, PostgreSQL Bugs <pgsql-bugs@postgresql.org>
Subject: Re: BUG #14637: Tests fail with pl_PL.UTF-8 locale
In-reply-to: 
 <CAE2gYzxCzO6qN_5Hune0SNrb-Ba=TH5c4cNrSB4UWUyVYJ_Ecg@mail.gmail.com>
References: <20170501000609.24360.24248@wrigleys.postgresql.org>
 <26c2d2e3-3ef0-09f8-f084-45ca6797d59f@2ndquadrant.com>
 <CAE2gYzxCzO6qN_5Hune0SNrb-Ba=TH5c4cNrSB4UWUyVYJ_Ecg@mail.gmail.com>
Comments: In-reply-to Emre Hasegeli <emre@hasegeli.com>
	message dated "Tue, 23 May 2017 10:27:30 +0200"
Date: Thu, 25 May 2017 10:15:58 -0400
Message-ID: <15699.1495721758@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-bugs-owner@postgresql.org

Emre Hasegeli <emre@hasegeli.com> writes:
> The select_views test has also confused me while I was working on the
> geometric types [1].  It is hard to figure out if the failure is
> positive or a collation issue.  I don't think this test is responsible
> from testing collations.  Can we change this to ORDER BY name COLLATE
> "C"?

Uh, change what exactly?

FWIW, I tried to reproduce the OP's reported failure with pl_PL.UTF-8,
but it seems to pass fine for me.  This implies that that locale works
differently on his Ubuntu box than my RHEL box, which makes the idea
of trying to guarantee that it works even more problematic.

			regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs