如何在postgresql的列表分区中存储其他值

-- 创建主表
CREATE TABLE orders (
    order_id SERIAL PRIMARY KEY,
    order_status VARCHAR(50),
    order_date DATE
) PARTITION BY LIST (order_status);

-- 创建分区
CREATE TABLE orders_processed PARTITION OF orders FOR VALUES IN ('processed');
CREATE TABLE orders_pending PARTITION OF orders FOR VALUES IN ('pending');
CREATE TABLE orders_other PARTITION OF orders DEFAULT;

-- 插入数据
INSERT INTO orders (order_status, order_date) VALUES ('processed', CURRENT_DATE);
INSERT INTO orders (order_status, order_date) VALUES ('pending', CURRENT_DATE);
INSERT INTO orders (order_status, order_date) VALUES ('cancelled', CURRENT_DATE); -- 这将进入默认分区

CREATE INDEX idx_orders_status_ci ON orders USING btree (lower(order_status));