--

-- Tests forpg_partition_tree

-- Tests forfunctions providing information about partitions

--

SELECT * FROM pg_partition_tree(NULL);

relid | parentrelid | isleaf | level

(1 row)

DROP TABLE ptif_test;

--A tablenot part ofa partition tree works is the only member listed.

--Table that isnot part ofany partition tree is the only member listed.

CREATE TABLE ptif_normal_table(a int);

SELECT relid, parentrelid, level, isleaf

FROM pg_partition_tree('ptif_normal_table');

(1 row)

DROP TABLE ptif_normal_table;

-- Views and materialized viewS cannot be part of a partition tree.

-- Various partitioning-related functions return NULL if passed relations

-- of types that cannot be part of a partition tree; for example, views,

-- materialized views, etc.

CREATE VIEW ptif_test_view AS SELECT 1;

CREATE MATERIALIZED VIEW ptif_test_matview AS SELECT 1;

SELECT * FROM pg_partition_tree('ptif_test_view');

SELECT*FROM pg_partition_tree(NULL);

SELECT*FROM pg_partition_tree(0);

DROPTABLE ptif_test;

CREATETABLEptif_normal_table(aint);

SELECT relid, parentrelid, level, isleaf

FROM pg_partition_tree('ptif_normal_table');

DROPTABLE ptif_normal_table;

CREATEVIEWptif_test_viewASSELECT1;

CREATE MATERIALIZED VIEW ptif_test_matviewASSELECT1;

SELECT*FROM pg_partition_tree('ptif_test_view');