I have noticed the following behaviour in range partitioning which i felt
is not quite correct (i missed reporting this) -
I have tested by creating a date ranged partition.
I created the following table.
db03=# CREATE TABLE orders (
o_comment VARCHAR(79)) partition by range (o_orderdate);
Created the following partitioned tables :
db03=# CREATE TABLE orders_y1992
PARTITION OF orders FOR VALUES FROM ('1992-01-01') TO ('1992-12-31');
db03=# CREATE TABLE orders_y1993
PARTITION OF orders FOR VALUES FROM ('1993-01-01') TO ('*1993-12-31'*);
db03=# CREATE TABLE orders_y1994
PARTITION OF orders FOR VALUES FROM ('1994-01-01') TO ('1994-12-31');
The rows with the date "1993-12-31" gets rejected as shown below -
db03=# copy orders from '/data/orders.csv' delimiter '|';
ERROR: no partition of relation "orders" found for row
DETAIL: Failing row contains (353, 8878, F, 273342, *1993-12-31*, 5-LOW
, Clerk#000002241, 0, quiet ideas sleep. even instructions cajole
slyly. silently spe).
CONTEXT: COPY orders, line 89: "353|8878|F|273342|*1993-12-31*|5-LOW
|Clerk#000002241|0| quiet ideas sleep. even instructions..."
I would want the partition "orders_y1993" to accept all the rows with the
To confirm this behaviour, I did another simple test with numbers -
I created two partitioned tables with range values from 1 to 5 and from 6
to 10 as shown below -
db03=# create table test_part ( col int) partition by range (col);
db03=# create table test_part_5 partition of test_part for values from (1)
db03=# create table test_part_10 partition of test_part for values from (6)
When i try to insert value 5, it gets rejected as shown below
db03=# insert into test_part values (5);
ERROR: no partition of relation "test_part" found for row
DETAIL: Failing row contains (5).
The table partition "test_part_5" is not supposed to accept value 5 ?
Am i missing anything here ?
Venkata B N