Steve, Peter,
thanks .
Below query works. the view is used to generate the stats and not using the
table http_ping_uptime_stats . So my interpretation was that I need to
alias the view for the UPDATE to know where the value is coming from as
both have the same name.
That obviously did not work. I
On Wed, Nov 3, 2021 at 2:18 PM Steve Baldwin wrote:
> I'm pretty sure the 'alias' for the '.. on conflict do update ..' needs to be
> 'excluded' (i.e. checks = excluded.checks, ...). Check the docs.
That's right . The excluded.* pseudo-table isn't exactly the same
thing as the target table -- it
I'm pretty sure the 'alias' for the '.. on conflict do update ..' needs to
be 'excluded' (i.e. checks = excluded.checks, ...). Check the docs.
Steve
On Thu, Nov 4, 2021 at 8:05 AM Alex Magnum wrote:
> Hi,
> I am trying to do an upsert using a view but for some reason get errors.
> All works fin
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
