Hi, As the document explains, column defaults can be specified separately for each partition. But I found that INSERT via the partitioned table ignores that default. Is this expected behavior or bug?
CREATE TABLE test (i INT, j INT) PARTITION BY RANGE (i); CREATE TABLE test1 PARTITION OF test (j DEFAULT 99) FOR VALUES FROM (1) TO (10); INSERT INTO test VALUES (1, DEFAULT); INSERT INTO test1 VALUES (2, DEFAULT); SELECT * FROM test; i | j ---+-------- 1 | (null) 2 | 99 (2 rows) In the above example, INSERT accessing directly to the partition uses the default, but INSERT via the partitioned table not. Regards, -- Fujii Masao
