ponovljeni triggeri

PRE INSERTA PLATNE KARTICE
CREATE OR REPLACE FUNCTION platnaKartica()
RETURNS TRIGGER AS
       $$
     BEGIN
        NEW.ime = (SELECT ime FROM turista WHERE turista_id =  NEW.turista_id);
        RETURN NEW;
    END;
$$
LANGUAGE 'plpgsql';


CREATE TRIGGER pre_inserta_platne_kartice
 BEFORE INSERT ON platna_kartica
 FOR EACH ROW
 EXECUTE PROCEDURE platnaKartica();




POSLE IZMENE TURISTE

CREATE OR REPLACE FUNCTION posleIzmeneTuriste()
RETURNS TRIGGER AS
$$
       BEGIN
    IF NEW.ime <> OLD.ime THEN
	ALTER table platna_kartica DISABLE TRIGGER nakon_izmene_platne_kartice;
        UPDATE platna_kartica
        SET ime = NEW.ime
        WHERE turista_id = NEW.turista_id;
		ALTER table platna_kartica ENABLE TRIGGER nakon_izmene_platne_kartice;
    END IF;
        RETURN NEW;
    END;
$$
LANGUAGE 'plpgsql';

CREATE TRIGGER posle_izmene_turiste
    AFTER UPDATE ON turista
    FOR EACH ROW
EXECUTE PROCEDURE posleIzmeneTuriste();



POSLE IZMENE PLATNE KARTICE

CREATE OR REPLACE FUNCTION nakonIzmenePlatneKartice()
RETURNS TRIGGER AS
$$
    		BEGIN
	IF NEW.ime <> OLD.ime
	THEN
		RAISE EXCEPTION 'Ne mozete izmeniti zadatu kolonu!';
	END IF;
		RETURN NEW;
	END;

$$
LANGUAGE 'plpgsql';

CREATE TRIGGER nakon_izmene_platne_kartice
AFTER UPDATE ON platna_kartica
FOR EACH ROW
EXECUTE PROCEDURE nakonIzmenePlatneKartice();