Project

Profile

Help

HostedRedmine.com has moved to the Planio platform. All logins and passwords remained the same. All users will be able to login and use Redmine just as before. Read more...

PostgresDB Trigger Example

Technical documentation
2014-11-21

-- Trigger: gen_rpt on gs_node

-- DROP TRIGGER gen_rpt ON gs_node;

CREATE TRIGGER gen_rpt
AFTER INSERT OR UPDATE OR DELETE
ON gs_node
FOR EACH ROW
EXECUTE PROCEDURE gen_rpt_node();

-- Function: gen_rpt_node()

-- DROP FUNCTION gen_rpt_node();

CREATE OR REPLACE FUNCTION gen_rpt_node()
RETURNS trigger AS
$BODY$

DECLARE
        gs_id2          integer;
begin
IF (TG_OP = 'DELETE') THEN
        gs_id2 =OLD.gs_id;
        delete from gis_rpt_export_node where gs_id =gs_id2; 
        RETURN OLD;
        ELSIF (TG_OP = 'UPDATE') THEN
        gs_id2 =OLD.gs_id;
        delete from gis_rpt_export_node where gs_id =gs_id2; 
perform fn_rpt_export_node2(1,0,gs_id2) ;
        RETURN OLD;
        ELSIF (TG_OP = 'INSERT') THEN
        gs_id2 =NEW.gs_id;
        perform fn_rpt_export_node2(1,0,gs_id2) ;
        RETURN NEW;
        END IF;

end ;$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION gen_rpt_node() OWNER TO "admin";

Files