--
-- 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;