Question: Consider the following security trigger ALTER TABLE customer _ data ADD COLUMN is _ deleted BOOLEAN DEFAULT FALSE; CREATE OR REPLACE FUNCTION soft _ delete
Consider the following security trigger
ALTER TABLE customerdata ADD COLUMN isdeleted BOOLEAN DEFAULT FALSE;
CREATE OR REPLACE FUNCTION softdeletecustomer
RETURNS TRIGGER AS $$
BEGIN
NEW.isdeleted : TRUE;
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
CREATE TRIGGER triggersoftdeletecustomer
BEFORE DELETE ON customerdata
FOR EACH ROW EXECUTE FUNCTION softdeletecustomer;
What column does the softdeletecustomer function modify?
isactive
deletedat
isdeleted
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
