PG 14 range partitions creation works but subsequently can't be found correctly

Поиск
Список
Период
Сортировка
От Ian R. Campbell
Тема PG 14 range partitions creation works but subsequently can't be found correctly
Дата
Msg-id CAOC8YUfELpHXNopHiWQREZiDJmUEHw8po-k3KpZyrL9denm0+w@mail.gmail.com
обсуждение исходный текст
Ответы Re: PG 14 range partitions creation works but subsequently can't be found correctly
Список pgsql-bugs
Server: v14.1-1 x64 Windows

The following executes without problem:

CREATE TABLE part (
    h "char" not null,
    val int4 not null
) PARTITION BY RANGE (h);

create table part_00 partition of part FOR VALUES FROM ((-128)::"char") to ((-113)::"char");
create table part_01 partition of part FOR VALUES FROM ((-112)::"char") to ((-97)::"char");
create table part_02 partition of part FOR VALUES FROM ((-96)::"char") to ((-81)::"char");
create table part_03 partition of part FOR VALUES FROM ((-80)::"char") to ((-65)::"char");
create table part_04 partition of part FOR VALUES FROM ((-64)::"char") to ((-49)::"char");
create table part_05 partition of part FOR VALUES FROM ((-48)::"char") to ((-33)::"char");
create table part_06 partition of part FOR VALUES FROM ((-32)::"char") to ((-17)::"char");
create table part_07 partition of part FOR VALUES FROM ((-16)::"char") to ((-1)::"char");
create table part_08 partition of part FOR VALUES FROM (0::"char") to (15::"char");
create table part_09 partition of part FOR VALUES FROM (16::"char") to (31::"char");
create table part_10 partition of part FOR VALUES FROM (32::"char") to (47::"char");
create table part_11 partition of part FOR VALUES FROM (48::"char") to (63::"char");
create table part_12 partition of part FOR VALUES FROM (64::"char") to (79::"char");
create table part_13 partition of part FOR VALUES FROM (80::"char") to (95::"char");
create table part_14 partition of part FOR VALUES FROM (96::"char") to (111::"char");
create table part_15 partition of part FOR VALUES FROM (112::"char") to (127::"char");

In pgAdmin 4, navigating to "Partitions" (after refreshing) results only in a spinning wheel.

Any attempt to insert into this table fails with "no partition of relation "part" found for row".

The following does work (result 0):

select count(1) from part_00;

Rebooting the server doesn't help.

Ian Campbell

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

Предыдущее
От: Dmitry Koval
Дата:
Сообщение: Re: BUG #17288: PSQL bug with COPY command (Windows)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PG 14 range partitions creation works but subsequently can't be found correctly