Re: BUG #14327: UPSERT requires full path to column - Mailing list pgsql-bugs

On Mon, Sep 19, 2016 at 1:06 AM,  <egor.pugin@gmail.com> wrote:
> I've noticed upsert query won't work if I do not write 'schema.TABLE.column'
> instead of simple 'column' in 'on conflict do update set' query.

Use an alias. e.g.:

INSERT INTO statistics."MostPopularDependencies" as mpd ...

You can then reference columns using mpd.downloads_week, etc

--
Peter Geoghegan