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 customer_data ADD COLUMN is_deleted BOOLEAN DEFAULT FALSE;
CREATE OR REPLACE FUNCTION soft_delete_customer()
RETURNS TRIGGER AS $$
BEGIN
NEW.is_deleted := TRUE;
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
CREATE TRIGGER trigger_soft_delete_customer
BEFORE DELETE ON customer_data
FOR EACH ROW EXECUTE FUNCTION soft_delete_customer();
What column does the soft_delete_customer function modify?
is_active
deleted_at
is_deleted
 Consider the following security trigger ALTER TABLE customer_data ADD COLUMN is_deleted

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!