customer_table_triggers.sql

customer_table_triggers.sql

create function customer_search_customer_update()
   returns trigger
   security definer
   language plpgsql
as $$
begin
   update customer_search
   set is_stale=true,
       name=new.name,
       deleted_at=new.deleted_at
   where customer_id=new.id
         and is_stale<>true;
   return new;
end;
$$;
create trigger lazy_customer_update after update on customer
for each row execute procedure customer_search_customer_update();

create function customer_search_customer_delete()
   returns trigger
   security definer
   language plpgsql
as $$
begin
   delete from customer_search
   where customer_id=old.id;
   return old;
end;
$$;
create trigger lazy_customer_delete after delete on customer
for each row execute procedure customer_search_customer_delete();