Re: NEW in after insert trugger contained incorrect data

Brilliantov Kirill Vladimirovich wrote:
>> You should post the table definition and the whole trigger; the error
>> message seems to refer to things you omitted in your quote.
>
> Table with statistic:
> CREATE TABLE trassa.cpu_load_stat
> (
> id serial NOT NULL,
> device integer NOT NULL,
> cpu smallint NOT NULL,
> min_value smallint NOT NULL,
> min_device_timestamp timestamp without time zone NOT NULL,
> min_timestamp timestamp without time zone,
> avg_value smallint NOT NULL,
> avg_timestamp timestamp without time zone NOT NULL,
> max_value smallint NOT NULL,
> max_device_timestamp timestamp without time zone NOT NULL,
> max_timestamp timestamp without time zone,
> total_value bigint NOT NULL,
> total_count integer NOT NULL,
[...]
> )

> Trigger:
> CREATE OR REPLACE FUNCTION trassa.update_cpu_load_stat()
> RETURNS trigger AS
> $BODY$
[...]
> UPDATE trassa.cpu_load_stat
> SET min_value = cpu_min_value,
> min_device_timestamp = cpu_min_device_timestamp,
> min_timestamp = cpu_min_created_timestamp,
> avg_value = CEIL((total_value + NEW.value) /
> (total_count + 1)),
> avg_timestamp = NOW(),
> max_value = cpu_max_value,
> max_device_timestamp = cpu_max_device_timestamp,
> max_timestamp = cpu_max_created_timestamp,
> total_value = (total_value + NEW.value),
> total_count = (total_count + 1)
> WHERE id = line_id;

I'd say that the error message refers to this or the following query:

There is no field "value" in the table, and "NEW" represents a row in the table,
so the expression "NEW.value" does not make sense.

Yours,
Laurenz Albe