-- -- cr_keywords_update_tr/0 -- create or replace function cr_keywords_update_tr( ) returns trigger as $$ begin if old.parent_id <> new.parent_id then update acs_objects set context_id = new.parent_id where object_id = new.keyword_id; end if; return new; end;$$ language plpgsql;