<listitem>

<para>

<command>INSERT</command> statements with <literal>ON CONFLICT</>

clause are currently not allowed on partitioned tables.

Using the <literal>ON CONFLICT</literal> clause with partitioned tables

will cause an error if <literal>DO UPDATE</literal> is specified as the

alternative action, because unique or exclusion constraints can only be

created on individual partitions. There is no support for enforcing

uniqueness (or an exclusion constraint) across an entire partitioning

hierarchy.

</para>

</listitem>

if (stmt->onConflictClause)

{

if (pstate->p_target_rangetblentry->relkind==RELKIND_PARTITIONED_TABLE)

ereport(ERROR,

(errcode(ERRCODE_FEATURE_NOT_SUPPORTED),

errmsg("ON CONFLICT clause is not supported with partitioned tables")));

qry->onConflict=transformOnConflictClause(pstate,

stmt->onConflictClause);

}

(3 rows)

drop table selfconflict;

-- check that the following works:

-- insert into partitioned_table on conflict do nothing

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

create table parted_conflict_test_1 partition of parted_conflict_test for values in (1);

insert into parted_conflict_test values (1, 'a') on conflict do nothing;

insert into parted_conflict_test values (1, 'a') on conflict do nothing;

-- however, on conflict do update not supported yet

insert into parted_conflict_test values (1) on conflict (a) do update set b = excluded.b where excluded.a = 1;

ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification

drop table parted_conflict_test, parted_conflict_test_1;

select*from selfconflict;

droptable selfconflict;

createtableparted_conflict_test (aint, bchar) partition by list (a);

createtableparted_conflict_test_1 partition of parted_conflict_test forvaluesin (1);

insert into parted_conflict_testvalues (1,'a')on conflict do nothing;

insert into parted_conflict_testvalues (1,'a')on conflict do nothing;

insert into parted_conflict_testvalues (1)on conflict (a) doupdateset b=excluded.bwhereexcluded.a=1;

droptable parted_conflict_test, parted_conflict_test_1;