Ad Widget

**cyber** · 11-06-2024, 08:17

It says "trigger "items_name_upper_insert" for table "items" does not exist" .. so you are already in your 6.4 missing a trigger, which makes me wonder, how it even worked... If you look into DB and items table.. do you see something like

Code:

Triggers:
    items_name_upper_insert AFTER INSERT ON items FOR EACH ROW EXECUTE FUNCTION items_name_upper_upper()
    items_name_upper_update AFTER UPDATE OF name ON items FOR EACH ROW EXECUTE FUNCTION items_name_upper_upper()

If not, then you should maybe create those... look for a schema.sql file in installation package and find that section that creates ...
something like this

Code:

create or replace function items_name_upper_upper()
returns trigger language plpgsql as $func$
begin
update items set name_upper=upper(name)
where itemid=new.itemid;
return null;
end $func$;
create trigger items_name_upper_insert after insert
on items
for each row execute function items_name_upper_upper();
create trigger items_name_upper_update after update
of name on items
for each row execute function items_name_upper_upper();

**cyber** · 11-06-2024, 08:17

It says "trigger "items_name_upper_insert" for table "items" does not exist" .. so you are already in your 6.4 missing a trigger, which makes me wonder, how it even worked... If you look into DB and items table.. do you see something like

Code:

Triggers:
    items_name_upper_insert AFTER INSERT ON items FOR EACH ROW EXECUTE FUNCTION items_name_upper_upper()
    items_name_upper_update AFTER UPDATE OF name ON items FOR EACH ROW EXECUTE FUNCTION items_name_upper_upper()

If not, then you should maybe create those... look for a schema.sql file in installation package and find that section that creates ...
something like this

Code:

create or replace function items_name_upper_upper()
returns trigger language plpgsql as $func$
begin
update items set name_upper=upper(name)
where itemid=new.itemid;
return null;
end $func$;
create trigger items_name_upper_insert after insert
on items
for each row execute function items_name_upper_upper();
create trigger items_name_upper_update after update
of name on items
for each row execute function items_name_upper_upper();

**whanklee** · 11-06-2024, 18:23

Thank you very much.

Yes, I had to create trigger and now it works well after upgrading.

Code:

[2024-06-11 18:03:03] Connected to zabbix
zabbix> create or replace function items_name_upper_upper()
        returns trigger language plpgsql as $func$
        begin
        update items set name_upper=upper(name)
        where itemid=new.itemid;
        return null;
        end $func$
[2024-06-11 18:03:03] completed in 58 ms
zabbix> create trigger items_name_upper_insert after insert
        on items
        for each row execute function items_name_upper_upper()
[2024-06-11 18:03:04] completed in 44 ms
zabbix> create trigger items_name_upper_update after update
        of name on items
        for each row execute function items_name_upper_upper()
[2024-06-11 18:03:04] completed in 40 ms

**JeanForsberg** · 12-07-2024, 11:58

I appreciate the answer, I am also trying to resolve it.

Ad Widget

Upgrading issue: PGRES_FATAL_ERROR:ERROR

Upgrading issue: PGRES_FATAL_ERROR:ERROR

Comment

Comment

Comment

Comment