O kyrios Jeff Post egrapse stis May 19, 2004 : > I would like to have a trigger that fires whenever a delete is attempted. > The trigger should update the status field of the tupple (to remove the > tupple form the active set of tupples). >
A rule would be more appropriate for this task. > > Here is what I got: > > CREATE or replace FUNCTION person_fake_delete() RETURNS TRIGGER AS ' > BEGIN > OLD.status := 1; -- This does the fake deletion > RETURN NULL; -- I thought this would prevent the delete from > actually happening. > END; > ' LANGUAGE 'plpgsql'; > > create trigger person_fake_delete > before delete on person > for each row EXECUTE PROCEDURE > person_fake_delete(); > > This however does not work. the tupple is still deleted from the > table. Any Ideas? > > Thanks, > Jeff Post > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- -Achilleus ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
