Preventing Deletions with triggers - Mailing list pgsql-sql

From Jeff Post
Subject Preventing Deletions with triggers
Date
Msg-id 6.1.0.6.0.20040519090934.025963a8@mail.milwaukee.k12.wi.us
Whole thread Raw
Responses Re: Preventing Deletions with triggers
Re: Preventing Deletions with triggers
Re: Preventing Deletions with triggers
List pgsql-sql
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).


Here is what I got:

CREATE or replace FUNCTION person_fake_delete() RETURNS TRIGGER AS '    BEGIN        OLD.status := 1; -- This does the
fakedeletion        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



pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: v7.2 triggers and foreign keys
Next
From: Charlie Clark
Date:
Subject: Problem with JOINS