1 -- NO create trigger statements. the updater will create them.
3 SELECT dropIfExists('TRIGGER', 'pkgscriptbeforetrigger');
4 CREATE OR REPLACE FUNCTION _pkgscriptbeforetrigger() 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 _pkgscriptalterTrigger() 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 scripts in packages except using the xTuple Updater utility';
41 ELSIF (TG_OP = 'UPDATE') THEN
42 RAISE EXCEPTION 'You may not alter scripts in packages except using the xTuple Updater utility';
44 ELSIF (TG_OP = 'DELETE') THEN
45 RAISE EXCEPTION 'You may not delete scripts from packages. Try deleting or disabling the package.';
51 $$ LANGUAGE 'plpgsql';
53 CREATE OR REPLACE FUNCTION _pkgscriptaftertrigger() RETURNS TRIGGER AS $$
54 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
55 -- See www.xtuple.com/CPAL for the full text of the software license.
57 IF (TG_OP = 'DELETE') THEN
63 $$ LANGUAGE 'plpgsql';