1 CREATE OR REPLACE FUNCTION _commentTrigger () RETURNS TRIGGER AS $$
2 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
3 -- See www.xtuple.com/CPAL for the full text of the software license.
5 IF (NEW.comment_cmnttype_id IS NULL) THEN
6 RAISE EXCEPTION 'You must supply a valid Comment Type ID.';
7 ELSIF (NEW.comment_source = 'INCDT') THEN
8 UPDATE incdt SET incdt_updated = now() WHERE incdt_id = NEW.comment_source_id;
13 $$ LANGUAGE 'plpgsql';
15 DROP TRIGGER IF EXISTS commentTrigger ON comment;
16 CREATE TRIGGER commentTrigger AFTER INSERT OR UPDATE ON comment FOR EACH ROW EXECUTE PROCEDURE _commentTrigger();