OidtablespaceId;

OidcreatedConstraintId=InvalidOid;

List*indexColNames;

List*allIndexParams;

Relationrel;

RelationindexRelation;

HeapTupletuple;

numberOfKeyAttributes=list_length(stmt->indexParams);

stmt->indexParams=list_concat(stmt->indexParams,

stmt->indexIncludingParams);

numberOfAttributes=list_length(stmt->indexParams);

allIndexParams=list_concat(list_copy(stmt->indexParams),

list_copy(stmt->indexIncludingParams));

numberOfAttributes=list_length(allIndexParams);

if (numberOfAttributes <=0)

ereport(ERROR,

indexColNames=ChooseIndexColumnNames(stmt->indexParams);

indexColNames=ChooseIndexColumnNames(allIndexParams);

coloptions= (int16*)palloc(numberOfAttributes*sizeof(int16));

ComputeIndexAttrs(indexInfo,

typeObjectId,collationObjectId,classObjectId,

coloptions,stmt->indexParams,

coloptions,allIndexParams,

stmt->excludeOpNames,relationId,

accessMethodName,accessMethodId,

amcanorder,stmt->isconstraint);

memcpy(part_oids,partdesc->oids,sizeof(Oid)*nparts);

parentDesc=CreateTupleDescCopy(RelationGetDescr(rel));

opfamOids=palloc(sizeof(Oid)*numberOfAttributes);

for (i=0;i<numberOfAttributes;i++)

opfamOids=palloc(sizeof(Oid)*numberOfKeyAttributes);

for (i=0;i<numberOfKeyAttributes;i++)

opfamOids[i]=get_opclass_family(classObjectId[i]);

heap_close(rel,NoLock);

create index on idxpart (a);

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

create table idxpart_another_1 partition of idxpart_another for values from (0) to (100);

-- Test that covering partitioned indexes work in various cases

create table covidxpart (a int, b int) partition by list (a);

create unique index on covidxpart (a) include (b);

create table covidxpart1 partition of covidxpart for values in (1);

create table covidxpart2 partition of covidxpart for values in (2);

insert into covidxpart values (1, 1);

insert into covidxpart values (1, 1);

ERROR: duplicate key value violates unique constraint "covidxpart1_a_b_idx"

DETAIL: Key (a)=(1) already exists.

create table covidxpart3 (b int, c int, a int);

alter table covidxpart3 drop c;

alter table covidxpart attach partition covidxpart3 for values in (3);

insert into covidxpart values (3, 1);

insert into covidxpart values (3, 1);

ERROR: duplicate key value violates unique constraint "covidxpart3_a_b_idx"

DETAIL: Key (a)=(3) already exists.

create table covidxpart4 (b int, a int);

create unique index on covidxpart4 (a) include (b);

create unique index on covidxpart4 (a);

alter table covidxpart attach partition covidxpart4 for values in (4);

insert into covidxpart values (4, 1);

insert into covidxpart values (4, 1);

ERROR: duplicate key value violates unique constraint "covidxpart4_a_b_idx"

DETAIL: Key (a)=(4) already exists.

createindexon idxpart (a);

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

createtableidxpart_another_1 partition of idxpart_another forvaluesfrom (0) to (100);

createtablecovidxpart (aint, bint) partition by list (a);

createunique indexon covidxpart (a) include (b);

createtablecovidxpart1 partition of covidxpart forvaluesin (1);

createtablecovidxpart2 partition of covidxpart forvaluesin (2);

insert into covidxpartvalues (1,1);

insert into covidxpartvalues (1,1);

createtablecovidxpart3 (bint, cint, aint);

altertable covidxpart3 drop c;

altertable covidxpart attach partition covidxpart3 forvaluesin (3);

insert into covidxpartvalues (3,1);

insert into covidxpartvalues (3,1);

createtablecovidxpart4 (bint, aint);

createunique indexon covidxpart4 (a) include (b);

createunique indexon covidxpart4 (a);

altertable covidxpart attach partition covidxpart4 forvaluesin (4);

insert into covidxpartvalues (4,1);

insert into covidxpartvalues (4,1);