{

Oididxid=lfirst_oid(cell);

Relationidx;

OidconstrOid;

if (!has_superclass(idxid))

continue;

IndexSetParentIndex(idx,InvalidOid);

update_relispartition(classRel,idxid, false);

index_close(idx,NoLock);

if (!idx->rd_index->indisprimary&& !idx->rd_index->indisunique)

continue;

constrOid=get_relation_idx_constraint_oid(RelationGetRelid(partRel),

idxid);

if (!OidIsValid(constrOid))

elog(ERROR,"missing pg_constraint entry of index \"%s\" of partition \"%s\"",

RelationGetRelationName(idx),

RelationGetRelationName(partRel));

ConstraintSetParentConstraint(constrOid,InvalidOid);

}

heap_close(classRel,RowExclusiveLock);

create unique index on covidxpart (b) include (a); -- should fail

ERROR: insufficient columns in UNIQUE constraint definition

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

-- check that detaching a partition also detaches the primary key constraint

create table parted_pk_detach_test (a int primary key) partition by list (a);

create table parted_pk_detach_test1 partition of parted_pk_detach_test for values in (1);

alter table parted_pk_detach_test1 drop constraint parted_pk_detach_test1_pkey;-- should fail

ERROR: cannot drop inherited constraint "parted_pk_detach_test1_pkey" of relation "parted_pk_detach_test1"

alter table parted_pk_detach_test detach partition parted_pk_detach_test1;

alter table parted_pk_detach_test1 drop constraint parted_pk_detach_test1_pkey;

drop table parted_pk_detach_test, parted_pk_detach_test1;

create table parted_uniq_detach_test (a int unique) partition by list (a);

create table parted_uniq_detach_test1 partition of parted_uniq_detach_test for values in (1);

alter table parted_uniq_detach_test1 drop constraint parted_uniq_detach_test1_a_key;-- should fail

ERROR: cannot drop inherited constraint "parted_uniq_detach_test1_a_key" of relation "parted_uniq_detach_test1"

alter table parted_uniq_detach_test detach partition parted_uniq_detach_test1;

alter table parted_uniq_detach_test1 drop constraint parted_uniq_detach_test1_a_key;

drop table parted_uniq_detach_test, parted_uniq_detach_test1;

insert into covidxpartvalues (4,1);

insert into covidxpartvalues (4,1);

createunique indexon covidxpart (b) include (a);-- should fail

createtableparted_pk_detach_test (aintprimary key) partition by list (a);

createtableparted_pk_detach_test1 partition of parted_pk_detach_test forvaluesin (1);

altertable parted_pk_detach_test1 dropconstraint parted_pk_detach_test1_pkey;-- should fail

altertable parted_pk_detach_test detach partition parted_pk_detach_test1;

altertable parted_pk_detach_test1 dropconstraint parted_pk_detach_test1_pkey;

droptable parted_pk_detach_test, parted_pk_detach_test1;

createtableparted_uniq_detach_test (aint unique) partition by list (a);

createtableparted_uniq_detach_test1 partition of parted_uniq_detach_test forvaluesin (1);

altertable parted_uniq_detach_test1 dropconstraint parted_uniq_detach_test1_a_key;-- should fail

altertable parted_uniq_detach_test detach partition parted_uniq_detach_test1;

altertable parted_uniq_detach_test1 dropconstraint parted_uniq_detach_test1_a_key;

droptable parted_uniq_detach_test, parted_uniq_detach_test1;