for (i=0;i<key->partnatts;i++)

{

if (isnull[i]&&

partition_bound_has_default(partdesc->boundinfo))

if (isnull[i])

{

range_partkey_has_null= true;

part_index=partdesc->boundinfo->default_index;

break;

}

}

create table mcrparted3 partition of mcrparted for values from (11, 1, 1) to (20, 10, 10);

create table mcrparted4 partition of mcrparted for values from (21, minvalue, minvalue) to (30, 20, maxvalue);

create table mcrparted5 partition of mcrparted for values from (30, 21, 20) to (maxvalue, maxvalue, maxvalue);

-- null not allowed in range partition

insert into mcrparted values (null, null, null);

ERROR: no partition of relation "mcrparted" found for row

DETAIL: Partition key of the failing row contains (a, abs(b), c) = (null, null, null).

-- routed to mcrparted0

insert into mcrparted values (0, 1, 1);

insert into mcrparted0 values (0, 1, 1);

createtablemcrparted4 partition of mcrparted forvaluesfrom (21, minvalue, minvalue) to (30,20, maxvalue);

createtablemcrparted5 partition of mcrparted forvaluesfrom (30,21,20) to (maxvalue, maxvalue, maxvalue);

insert into mcrpartedvalues (null,null,null);

insert into mcrpartedvalues (0,1,1);

insert into mcrparted0values (0,1,1);