Hi,I am trying to do an upsert using a view but for some reason get errors. All works fine without the ON CONFLICTINSERT INTO http_statsSELECT * 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:3460Any help would be appreciated. Thanks in advance.A
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных