src/test/regress/sql/partition_unlogged.sql

-- Given an unlogged partition table with two leaf partitions
CREATE UNLOGGED TABLE unlogged_pt1(a int) PARTITION BY RANGE(a) (START(1) END(4) EVERY (2));
SELECT relpersistence, relname FROM pg_class WHERE relname like 'unlogged_pt1%';
-- When I split the first partition
ALTER TABLE unlogged_pt1 SPLIT PARTITION FOR(2) AT(2) INTO (PARTITION p1, PARTITION p2);
-- Then the resulting two new relations have relation persistence type 'u' for unlogged
SELECT relpersistence, relname FROM pg_class WHERE relname like 'unlogged_pt1%';

-- Given a permanent table
CREATE TABLE perm_tab(a INT);
-- When I exchange partition 2 from unlogged_pt1 with this permanent table, perm_tab
ALTER TABLE unlogged_pt1 EXCHANGE PARTITION FOR (3) WITH TABLE perm_tab;