LIST partitioned table does not get new partitions with run_maintenance* calls

[kmustkivi]

Hello,

Am I doing something wrong or perhaps I have stumbled upon a bug that affects LIST partitioned tables but here is the POC tested on PG v14.13, pg_partman v5.1.0:

CREATE SCHEMA IF NOT EXISTS partman_test;

CREATE TABLE partman_test.id_listpart_table (
    id      bigint NOT NULL GENERATED ALWAYS AS IDENTITY
  , partkey bigint
  , PRIMARY KEY (partkey, id)
)
PARTITION BY LIST (partkey);

CREATE INDEX ON partman_test.id_listpart_table (partkey);

\d+ partman_test.id_listpart_table

SELECT partman.create_parent(
    p_parent_table := 'partman_test.id_listpart_table'
  , p_control      := 'partkey'
  , p_interval     := '1'
  , p_type         := 'list'
);

\d+ partman_test.id_listpart_table

INSERT INTO partman_test.id_listpart_table (partkey) VALUES (0);
INSERT INTO partman_test.id_listpart_table (partkey) VALUES (1);
INSERT INTO partman_test.id_listpart_table (partkey) VALUES (2);
INSERT INTO partman_test.id_listpart_table (partkey) VALUES (3);
INSERT INTO partman_test.id_listpart_table (partkey) VALUES (4);

CALL partman.run_maintenance_proc();

It seems that the function partman.show_partition_info called within the maintenance subroutines returns NULL values for all items and thus nothing gets done from there on.

[keithf4]

Turned this into Issue #704