Postgres On Conflict Set Column Reference Is Ambiguous

I have a table: create table c ( e text not null, m text not null, p numeric not null, PRIMARY KEY (e, m) ); and I want to do insert or update that adds p to exist

Solution 1:

Well, you probably want:

p = c.p + excluded.p

It is possible that you want:

p = excluded.p + excluded.p

You need to specify.