CREATE OR REPLACE FUNCTION new_trig_func()
  RETURNS event_trigger AS
$BODY$
DECLARE
table_name text;
trig_name text;
BEGIN
IF tg_tag='CREATE TABLE' THEN
trig_name =table_name || '_trigger';
CREATE TRIGGER trig_name
  BEFORE DELETE
  ON table_name
  FOR EACH ROW
  EXECUTE PROCEDURE "BlobDel"();
END IF;
END;$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION new_trig_func()
  OWNER TO postgres;

CREATE OR REPLACE FUNCTION f_insert_newtab1()
  RETURNS trigger AS
$BODY$
DECLARE 
trig_name text;
BEGIN
trig_name=NEW.tname || '_trigger';
CREATE TRIGGER trig_name
  BEFORE DELETE
  ON NEW.tname
  FOR EACH ROW
  EXECUTE PROCEDURE "fclearhistory"();
END;$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION f_insert_newtab1()
  OWNER TO postgres;