Re: Docker image of 11~beta2-2 orders strings case-insensitively

Here is the output of running

docker run -it --rm --link POSTGRES11:postgres postgres psql -h postgres -U
postgres -l

List of databases

Name | Owner | Encoding | Collate | Ctype | Access
privileges

-----------+----------+----------+------------+------------+-----------------------

postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 |

template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres
+

| | | | |
postgres=CTc/postgres

template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres
+

| | | | |
postgres=CTc/postgres
I might be missing something, but it looks to me that I have regular
collation. Sorry, I don't have any experience with this.

Best,
Yahor Yuzefovich

On Mon, Aug 6, 2018 at 12:03 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Monday, August 6, 2018, Yahor Yuzefovich <yahor(at)cockroachlabs(dot)com>
> wrote:
>
>> Hello,
>>
>> I used these commands to run Beta PG 11:
>> docker pull postgres:11
>> docker run --name POSTGRES11 -e POSTGRES_PASSWORD=postgres -d postgres:11
>> docker run -it --rm --link POSTGRES11:postgres postgres psql -h postgres
>> -U postgres
>>
>> I've created a table as follows:
>> CREATE TABLE t (id serial PRIMARY KEY, name VARCHAR (255) NOT NULL);
>> INSERT INTO t (name) VALUES ('M'), ('i'), ('A');
>>
>> and ran this query:
>> SELECT name FROM t ORDER BY name;
>>
>> I expected to see:
>> A
>> M
>> i
>>
>> but found:
>> A
>> i
>> M
>>
>
> This is an environmental aspect (locale) of the docker image; not a bug.
> I suggest posting on -general, with details about your locale settings, if
> you would like some guidance in that area.
>
> David J.
>