Hi Mike, > Can anyone help me write a trigger on a table, I have > created an audit table for a table and what I want > trigger to do is to whenever a record is deleted from > the table it should first be inserted into the audit > table, just to keep track of whatever records are > deleted.
Is this something ?? This archives my adres changes. /* Archive function */ DROP FUNCTION fn_archive(); CREATE FUNCTION fn_archive() RETURNS OPAQUE AS ' BEGIN /* TG_OP is the function (UPDATE, DELETE, SELECT) */ INSERT INTO adres_archive VALUES (OLD.name,OLD.adres,OLD.tel,current_user,now(),tg_opt); NEW.modtime := ''now''; END IF; RETURN NEW; END; ' LANGUAGE 'plpgsql'; /* Archive trigger */ DROP TRIGGER tr_archive ON adres; CREATE TRIGGER tr_adres_archive BEFORE UPDATE OR DELETE ON adres FOR EACH ROW EXECUTE PROCEDURE fn_archive (); Ferdinand Smit ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly