blob: f32e49684f04587b281bee4e67ce924454e35ea1 [file] [log] [blame]
/*Standby_planning_status History*/
CREATE TABLE IF NOT EXISTS STANDBY_PLANNING_STATUS_HIST (HIST_ID serial, operation char(1), stamp timestamp, LIKE STANDBY_PLANNING_STATUS EXCLUDING ALL);
--
-- Create a row in {0}.standby_planning_status_hist_audit to reflect the operation performed on standby_planning_status,
-- making use of the special variable TG_OP to work out the operation.
--
CREATE OR REPLACE FUNCTION process_standby_planning_status_audit() RETURNS TRIGGER AS $object_audit$ BEGIN IF (TG_OP = 'DELETE') THEN INSERT INTO {0}.standby_planning_status_hist SELECT nextval('standby_planning_status_hist_hist_id_seq'), 'D', now(), OLD.*; ELSIF (TG_OP = 'UPDATE') THEN INSERT INTO {0}.standby_planning_status_hist SELECT nextval('standby_planning_status_hist_hist_id_seq'), 'U', now(), NEW.*; ELSIF (TG_OP = 'INSERT') THEN INSERT INTO {0}.standby_planning_status_hist SELECT nextval('standby_planning_status_hist_hist_id_seq'), 'I', now(), NEW.*; END IF; RETURN NULL; END; $object_audit$ LANGUAGE plpgsql;
DROP TRIGGER IF EXISTS standby_planning_status_audit on {0}.standby_planning_status;
CREATE TRIGGER standby_planning_status_audit AFTER INSERT OR UPDATE OR DELETE ON {0}.standby_planning_status FOR EACH ROW EXECUTE PROCEDURE process_standby_planning_status_audit();