create_tables.pgsql
changeset 63 9b627307f4a8
parent 42 9d10877e1c10
child 67 e4d25f50164d
equal deleted inserted replaced
62:869de537a020 63:9b627307f4a8
   190     RETURN NEW;
   190     RETURN NEW;
   191 END;
   191 END;
   192 $$ LANGUAGE plpgsql STABLE;
   192 $$ LANGUAGE plpgsql STABLE;
   193 
   193 
   194 
   194 
   195 CREATE TRIGGER primary_count BEFORE INSERT OR UPDATE ON domain_name
   195 CREATE TRIGGER primary_count_ins BEFORE INSERT ON domain_name
   196     FOR EACH ROW EXECUTE PROCEDURE domain_primary_trigger();
   196     FOR EACH ROW EXECUTE PROCEDURE domain_primary_trigger();
       
   197 
       
   198 CREATE TRIGGER primary_count_upd AFTER UPDATE ON domain_name
       
   199     FOR EACH ROW EXECUTE PROCEDURE domain_primary_trigger();