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

Поиск
Список
Период
Сортировка
От Yahor Yuzefovich
Тема Re: Docker image of 11~beta2-2 orders strings case-insensitively
Дата
Msg-id CABz5gWFzBHHoEZkj-mgEcyoPZgOFSJQUr2wdcTxUc7GOoURUvA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Docker image of 11~beta2-2 orders strings case-insensitively  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Docker image of 11~beta2-2 orders strings case-insensitively
Список pgsql-bugs
Дерево обсуждения
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.g.johnston@gmail.com> wrote:
On Monday, August 6, 2018, Yahor Yuzefovich <yahor@cockroachlabs.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.

В списке pgsql-bugs по дате отправления: