1 CREATE TRIGGER x_dragon_item_beforetrigger
5 EXECUTE PROCEDURE x_dragon_item_trigger_before();
9 CREATE OR REPLACE FUNCTION x_dragon_item_trigger_before()
14 -- Override values to avoid invalid data combinations
15 IF (NEW.item_number != OLD.item_number) THEN
16 RAISE EXCEPTION 'changing item number is not allowed. from % to %', OLD.item_number, NEW.item_number;
23 LANGUAGE plpgsql VOLATILE
25 ALTER FUNCTION x_dragon_item_trigger_before()