So, i have a procedure..
create or replace procedure pro_update_last_read(in input_sensor_id integer, in read_time timestamp) as $$ begin update sensor set last_read = read_time where sensor_id = input_sensor_id; end; $$ language plpgsql;
And a trigger that calls it...
create trigger tri_last_read after insert or update of report_time on report execute procedure pro_update_last_read(sensor_id, report_time);
however, when creating the trigger, I get the error message
 ERROR: function pro_update_last_read() does not exist
Does anyone have any idea why this error is happening?