CREATE TABLE foo ( a int PRIMARY KEY, b int );

INSERT INTO foo
  SELECT 5 AS z
ON CONFLICT (a)
DO UPDATE SET b = z;

ERROR:  column "z" does not exist
LINE 4:     DO UPDATE SET b = z;
                              ^