--
-- cr_items_update_tr/0
--
create or replace function cr_items_update_tr(
  
) returns trigger as $$

begin

  if new.parent_id <> old.parent_id then
    update acs_objects set context_id = new.parent_id
    where object_id = new.item_id;
  end if;

  return new;
end;$$ language plpgsql;