Hi, I am trying to do an upsert using a view but for some reason get errors. All works fine without the ON CONFLICT
INSERT INTO http_stats SELECT * FROM view_http_stats AS V WHERE month =date_trunc('month',now()) ON CONFLICT (url,ip,month) DO UPDATE SET last_update = now(), checks = V.checks, uptime = V.uptime, errors = V.errors; ERROR: 42P01: missing FROM-clause entry for table "v" LINE 5: checks = V.checks, ^ LOCATION: errorMissingRTE, parse_relation.c:3460 Any help would be appreciated. Thanks in advance. A