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

From: "Ian R(dot) Campbell" <ian(dot)campbell(at)thepathcentral(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: PG 14 range partitions creation works but subsequently can't be found correctly
Date: 2021-11-24 15:23:03
Message-ID: CAOC8YUfELpHXNopHiWQREZiDJmUEHw8po-k3KpZyrL9denm0+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-11-24 17:58:22 Re: PG 14 range partitions creation works but subsequently can't be found correctly
Previous Message Dmitry Koval 2021-11-24 07:44:09 Re: BUG #17288: PSQL bug with COPY command (Windows)