ereport(ERROR,

(errcode(ERRCODE_INVALID_OBJECT_DEFINITION),

errmsg("every hash partition modulus must be a factor of the next larger modulus"),

errdetail("The new modulus %d is not factor of %d, the modulus of existing partition \"%s\".",

errdetail("The new modulus %d is notafactor of %d, the modulus of existing partition \"%s\".",

spec->modulus,next_modulus,

get_rel_name(partdesc->oids[boundinfo->indexes[offset+1]]))));

}

CREATE TABLE hpart_1 PARTITION OF hash_parted FOR VALUES WITH (MODULUS 10, REMAINDER 0);

CREATE TABLE hpart_2 PARTITION OF hash_parted FOR VALUES WITH (MODULUS 50, REMAINDER 1);

CREATE TABLE hpart_3 PARTITION OF hash_parted FOR VALUES WITH (MODULUS 200, REMAINDER 2);

-- modulus 25 is factor of modulus of 50 but 10 is not factor of 25.

-- modulus 25 is factor of modulus of 50 but 10 is notafactor of 25.

CREATE TABLE fail_part PARTITION OF hash_parted FOR VALUES WITH (MODULUS 25, REMAINDER 3);

ERROR: every hash partition modulus must be a factor of the next larger modulus

DETAIL: The new modulus 25 is not divisible by 10, the modulus of existing partition "hpart_1".

-- previous modulus 50 is factor of 150 but this modulus is not factor of next modulus 200.

-- previous modulus 50 is factor of 150 but this modulus is notafactor of next modulus 200.

CREATE TABLE fail_part PARTITION OF hash_parted FOR VALUES WITH (MODULUS 150, REMAINDER 3);

ERROR: every hash partition modulus must be a factor of the next larger modulus

DETAIL: The new modulus 150 is not factor of 200, the modulus of existing partition "hpart_3".

DETAIL: The new modulus 150 is notafactor of 200, the modulus of existing partition "hpart_3".

-- trying to specify range for the hash partitioned table

CREATE TABLE fail_part PARTITION OF hash_parted FOR VALUES FROM ('a', 1) TO ('z');

ERROR: invalid bound specification for a hash partition

CREATETABLEhpart_1 PARTITION OF hash_parted FORVALUES WITH (MODULUS10, REMAINDER0);

CREATETABLEhpart_2 PARTITION OF hash_parted FORVALUES WITH (MODULUS50, REMAINDER1);

CREATETABLEhpart_3 PARTITION OF hash_parted FORVALUES WITH (MODULUS200, REMAINDER2);

CREATETABLEfail_part PARTITION OF hash_parted FORVALUES WITH (MODULUS25, REMAINDER3);

CREATETABLEfail_part PARTITION OF hash_parted FORVALUES WITH (MODULUS150, REMAINDER3);

CREATETABLEfail_part PARTITION OF hash_parted FORVALUESFROM ('a',1) TO ('z');