1 -- NO create trigger statements here. the updater will create them.
3 SELECT dropIfExists('TRIGGER', 'pkguiformbeforetrigger');
4 CREATE OR REPLACE FUNCTION _pkguiformbeforetrigger() RETURNS "trigger" AS $$
5 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
6 -- See www.xtuple.com/CPAL for the full text of the software license.
12 IF (TG_OP = 'UPDATE') THEN
15 ELSIF (TG_OP = 'INSERT') THEN
18 ELSIF (TG_OP = 'DELETE') THEN
24 $$ LANGUAGE 'plpgsql';
26 CREATE OR REPLACE FUNCTION _pkguiformalterTrigger() RETURNS TRIGGER AS $$
27 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
28 -- See www.xtuple.com/CPAL for the full text of the software license.
30 IF (pkgMayBeModified(TG_TABLE_SCHEMA) OR isDba()) THEN
31 IF (TG_OP = 'DELETE') THEN
38 IF (TG_OP = 'INSERT') THEN
39 RAISE EXCEPTION 'You may not create forms in packages except using the xTuple Updater utility';
41 ELSIF (TG_OP = 'UPDATE') THEN
42 RAISE EXCEPTION 'You may not alter forms in packages except using the xTuple Updater utility';
44 ELSIF (TG_OP = 'DELETE') THEN
45 RAISE EXCEPTION 'You may not delete forms from packages. Try deleting or disabling the package.';
52 $$ LANGUAGE 'plpgsql';
54 CREATE OR REPLACE FUNCTION _pkguiformaftertrigger() RETURNS TRIGGER AS $$
55 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
56 -- See www.xtuple.com/CPAL for the full text of the software license.
58 IF (TG_OP = 'DELETE') THEN
64 $$ LANGUAGE 'plpgsql';