[pi-code-cleaning] The is_trigger_enabled function has been deleted
authorNaroa Iriarte <naroa.iriarte@openbravo.com>
Tue, 26 Apr 2016 16:19:46 +0200
changeset 29515 17707aee7ca4
parent 29514 8496051fbd3b
child 29516 05b62a860514
[pi-code-cleaning] The is_trigger_enabled function has been deleted
src-db/database/model/prescript-PostgreSql.sql
--- a/src-db/database/model/prescript-PostgreSql.sql	Tue Apr 26 16:01:20 2016 +0200
+++ b/src-db/database/model/prescript-PostgreSql.sql	Tue Apr 26 16:19:46 2016 +0200
@@ -967,23 +967,6 @@
   RIGHTARG = numeric)
 /-- END
 
--- Auxiliar function for compatibility between 8.2 and 8.3 Postgres version.
-CREATE OR REPLACE FUNCTION is_Trigger_Enabled(tg_name "text")
-  RETURNS boolean AS
-$BODY$ 
-DECLARE
-  v_isEnabled boolean := false;
-BEGIN
-  SELECT tgenabled INTO v_isEnabled FROM pg_trigger WHERE UPPER(tgname) = UPPER(tg_name);
-  RETURN v_isEnabled;
-EXCEPTION
-WHEN OTHERS THEN
-  SELECT (UPPER(tgenabled)<>'D') INTO v_isEnabled FROM pg_trigger WHERE tgname = tg_name;
-  RETURN v_isEnabled;
-END;   $BODY$
-  LANGUAGE 'plpgsql' STABLE;
-/-- END
-
 -- Creating auxiliar functions for view dropping
 CREATE or REPLACE function drop_view (view_name IN varchar) returns varchar as '
 DECLARE