InvalidOid,/* no predefined OID */

indexRelationId,/* this is our child */

createdConstraintId,

false,check_rights,check_not_in_use,

is_alter_table,check_rights,check_not_in_use,

false,quiet);

}

DefineIndex(RelationGetRelid(attachrel),stmt,InvalidOid,

RelationGetRelid(idxRel),

constraintOid,

false, false, false, false, false);

true, false, false, false, false);

}

index_close(idxRel,AccessShareLock);

drop table idxpart;

-- Verify that multi-layer partitioning honors the requirement that all

-- columns in the partition key must appear in primary key

-- columns in the partition key must appear in primary/unique key

create table idxpart (a int, b int, primary key (a)) partition by range (a);

create table idxpart2 partition of idxpart

for values from (0) to (1000) partition by range (b); -- fail

ERROR: insufficient columns in PRIMARY KEY constraint definition

DETAIL: PRIMARY KEY constraint on table "idxpart2" lacks column "b" which is part of the partition key.

drop table idxpart;

-- Ditto for the ATTACH PARTITION case

create table idxpart (a intprimary key, b int) partition by range (a);

create table idxpart1 (a int not null, b int,primary key (a, b))

create table idxpart (a intunique, b int) partition by range (a);

create table idxpart1 (a int not null, b int,unique (a, b))

partition by range (a, b);

alter table idxpart attach partition idxpart1 for values from (1) to (1000);

ERROR: insufficient columns inPRIMARY KEY constraint definition

DETAIL:PRIMARY KEY constraint on table "idxpart1" lacks column "b" which is part of the partition key.

ERROR: insufficient columns inUNIQUE constraint definition

DETAIL:UNIQUE constraint on table "idxpart1" lacks column "b" which is part of the partition key.

DROP TABLE idxpart, idxpart1;

-- Multi-layer partitioning works correctly in this case:

create table idxpart (a int, b int, primary key (a, b)) partition by range (a);

(0 rows)

drop table idxpart;

-- If the partition to be attached already has a primary key, fail if

-- it doesn't match the parent's PK.

CREATE TABLE idxpart (c1 INT PRIMARY KEY, c2 INT, c3 VARCHAR(10)) PARTITION BY RANGE(c1);

CREATE TABLE idxpart1 (LIKE idxpart);

ALTER TABLE idxpart1 ADD PRIMARY KEY (c1, c2);

ALTER TABLE idxpart ATTACH PARTITION idxpart1 FOR VALUES FROM (100) TO (200);

ERROR: multiple primary keys for table "idxpart1" are not allowed

DROP TABLE idxpart, idxpart1;

-- Ditto if there is some distance between the PKs (subpartitioning)

create table idxpart (a int, b int, primary key (a)) partition by range (a);

create table idxpart1 (a int not null, b int) partition by range (a);

create table idxpart11 (a int not null, b int primary key);

alter table idxpart1 attach partition idxpart11 for values from (0) to (1000);

alter table idxpart attach partition idxpart1 for values from (0) to (10000);

ERROR: multiple primary keys for table "idxpart11" are not allowed

drop table idxpart, idxpart1, idxpart11;

-- If a partitioned table has a constraint whose index is not valid,

-- attaching a missing partition makes it valid.

create table idxpart (a int) partition by range (a);

droptable idxpart;

createtableidxpart (aint, bint,primary key (a)) partition by range (a);

createtableidxpart2 partition of idxpart

forvaluesfrom (0) to (1000) partition by range (b);-- fail

droptable idxpart;

createtableidxpart (aintprimary key, bint) partition by range (a);

createtableidxpart1 (aintnot null, bint,primary key (a, b))

createtableidxpart (aintunique, bint) partition by range (a);

createtableidxpart1 (aintnot null, bint,unique (a, b))

partition by range (a, b);

altertable idxpart attach partition idxpart1 forvaluesfrom (1) to (1000);

DROPTABLE idxpart, idxpart1;

order by indexrelid::regclass::text collate"C";

droptable idxpart;

CREATETABLEidxpart (c1INTPRIMARY KEY, c2INT, c3VARCHAR(10)) PARTITION BY RANGE(c1);

CREATETABLEidxpart1 (LIKE idxpart);

ALTERTABLE idxpart1 ADDPRIMARY KEY (c1, c2);

ALTERTABLE idxpart ATTACH PARTITION idxpart1 FORVALUESFROM (100) TO (200);

DROPTABLE idxpart, idxpart1;

createtableidxpart (aint, bint,primary key (a)) partition by range (a);

createtableidxpart1 (aintnot null, bint) partition by range (a);

createtableidxpart11 (aintnot null, bintprimary key);

altertable idxpart1 attach partition idxpart11 forvaluesfrom (0) to (1000);

altertable idxpart attach partition idxpart1 forvaluesfrom (0) to (10000);

droptable idxpart, idxpart1, idxpart11;

createtableidxpart (aint) partition by range (a);