flags |=INDEX_CREATE_PARTITIONED;

if (stmt->primary)

flags |=INDEX_CREATE_IS_PRIMARY;

if (partitioned&&stmt->relation&& !stmt->relation->inh)

flags |=INDEX_CREATE_INVALID;

{

PartitionDescpd=RelationGetPartitionDesc(rel);

if (pd->nparts!=0)

flags |=INDEX_CREATE_INVALID;

}

if (stmt->deferrable)

constr_flags |=INDEX_CONSTR_CREATE_DEFERRABLE;

-- partition

create table parted_conflict (a int, b text) partition by range (a);

create table parted_conflict_1 partition of parted_conflict for values from (0) to (1000) partition by range (a);

create table parted_conflict_1_1 partition of parted_conflict_1 for values from (0) to (500);

create unique index on only parted_conflict_1 (a);

create unique index on only parted_conflict (a);

alter index parted_conflict_a_idx attach partition parted_conflict_1_a_idx;

create table parted_conflict_1_1 partition of parted_conflict_1 for values from (0) to (500);

insert into parted_conflict values (40, 'forty');

insert into parted_conflict_1 values (40, 'cuarenta')

on conflict (a) do update set b = excluded.b;

createtableparted_conflict (aint, btext) partition by range (a);

createtableparted_conflict_1 partition of parted_conflict forvaluesfrom (0) to (1000) partition by range (a);

createtableparted_conflict_1_1 partition of parted_conflict_1 forvaluesfrom (0) to (500);

createunique indexon only parted_conflict_1 (a);

createunique indexon only parted_conflict (a);

alterindex parted_conflict_a_idx attach partition parted_conflict_1_a_idx;

createtableparted_conflict_1_1 partition of parted_conflict_1 forvaluesfrom (0) to (500);

insert into parted_conflictvalues (40,'forty');

insert into parted_conflict_1values (40,'cuarenta')

on conflict (a) doupdateset b=excluded.b;