blob: 26ec7c92113b3a73c9af00b826f846efa1ab70cd (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE OR REPLACE FUNCTION speaker_deleted()
RETURNS trigger AS $$
BEGIN
INSERT INTO confreg_deleteditems (itemid, type, deltime) VALUES (OLD.id, 'spk', CURRENT_TIMESTAMP);
RETURN NULL;
END;
$$ LANGUAGE 'plpgsql';
DROP TRIGGER IF EXISTS trg_speaker_deleted ON confreg_speaker;
CREATE TRIGGER trg_speaker_deleted
AFTER DELETE ON confreg_speaker
FOR EACH ROW EXECUTE PROCEDURE speaker_deleted();
|