CREATE TRIGGER acl_update_child AFTER UPDATE 
ON public."USER_ACL_LIST" FOR EACH ROW 
EXECUTE PROCEDURE public.acl_update_child();

CREATE OR REPLACE FUNCTION public.acl_update_child (
)
RETURNS trigger AS
$body$
DECLARE
hstore_new hstore;
hstore_old  hstore;
rec_user    RECORD;
st             RECORD;
query        TEXT;


  

BEGIN

 hstore_new =  hstore(NEW);
 hstore_old   =  hstore(OLD);
 
 --GET CHILD USER
 FOR rec_user IN SELECT "ID" FROM "USER_LIST" WHERE "OWNERID"=NEW."USERID" 
 LOOP
 	 FOR st IN SELECT * FROM  EACH(hstore_new)
     LOOP
      	IF hstore_old->st.key != st.value AND st.value = 'f' THEN
           query = 'UPDATE "USER_ACL_LIST" SET ' || quote_ident(st.key) || ' = false WHERE "USERID" = '|| rec_user."ID";
           EXECUTE (query);
        END IF;
     END LOOP;
 END LOOP;
RETURN NEW; 
END;
$body$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 100;