[PGS9.2] Trigger Sample Script

/****************************************************************************************************************
-- Title : [PGS9.2] Trigger Sample Script

-- Reference : dbrang.tistory.com
-- Key word : trigger 트리거 
****************************************************************************************************************/

-- drop trigger trg_film_fulltext_trigger on sch_film.film;

CREATE TRIGGER trg_film_fulltext_trigger BEFORE INSERT OR UPDATE 

ON sch_film.film 

FOR EACH ROW 

EXECUTE PROCEDURE tsvector_update_trigger('fulltext', 'pg_catalog.english', 'title', 'description');

-- drop trigger trg_last_updated on sch_film.actor;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_film.actor 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();

-- drop trigger trg_last_updated on sch_customer.address;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_customer.address 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();

-- drop trigger trg_last_updated on sch_film.category;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_film.category 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();

-- drop trigger trg_last_updated on sch_customer.city;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_customer.city 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();

-- drop trigger trg_last_updated on sch_customer.country;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_customer.country 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();

-- drop trigger trg_last_updated on sch_customer.customer;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_customer.customer 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();

-- drop trigger trg_last_updated on sch_film.film;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_film.film 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();

-- drop trigger trg_last_updated on sch_film.film_actor;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_film.film_actor 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();

-- drop trigger trg_last_updated on sch_film.film_category;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_film.film_category 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();

-- drop trigger trg_last_updated on sch_film.inventory;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_film.inventory 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();

-- drop trigger trg_last_updated on sch_film.language;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_film.language 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();

-- drop trigger trg_last_updated on sch_shop.rental;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_shop.rental 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();

-- drop trigger trg_last_updated on sch_shop.staff;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_shop.staff 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();

-- drop trigger trg_last_updated on sch_shop.store;

CREATE TRIGGER trg_last_updated BEFORE UPDATE 

ON sch_shop.store 

FOR EACH ROW 

EXECUTE PROCEDURE fn_last_updated();