1 -- NO create trigger statements. the updater will create them.
3 SELECT dropIfExists('TRIGGER', 'pkgcmdargbeforetrigger');
4 CREATE OR REPLACE FUNCTION _pkgcmdargbeforetrigger() 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 _pkgcmdargalterTrigger() 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)) THEN
31 IF (TG_OP = 'DELETE') THEN
38 IF (TG_OP = 'INSERT') THEN
39 RAISE EXCEPTION 'You may not create command arguments in packages except using the xTuple Updater utility';
41 ELSIF (TG_OP = 'UPDATE') THEN
42 RAISE EXCEPTION 'You may not alter command arguments in packages except using the xTuple Updater utility';
44 ELSIF (TG_OP = 'DELETE') THEN
45 RAISE EXCEPTION 'You may not delete command arguments from packages. Try deleting or disabling the package.';
52 $$ LANGUAGE 'plpgsql';
54 CREATE OR REPLACE FUNCTION _pkgcmdargaftertrigger() 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
63 $$ LANGUAGE 'plpgsql';