Consider the following PL$/$SQL function and trigger created for security reasons.

CREATE OR REPLACE FUNCTION prevent$\_$user$\_$deletion$()$

RETURNS TRIGGER AS $$

BEGIN

IF OLD.user$\_$role $=$ 'admin' THEN

RAISE EXCEPTION 'Cannot delete an admin user.$\text{'}$;

END IF;

RETURN OLD;

END;

$$ LANGUAGE plpgsql;

CREATE TRIGGER check$\_$user$\_$deletion

BEFORE DELETE ON users

FOR EACH ROW EXECUTE FUNCTION prevent$\_$user$\_$deletion$()$;

What can be said in regards to the check$\_$user$\_$deletion trigger and the prevent$\_$user$\_$deletion function?

The function contents could have been put directly in the trigger but this is a "cleaner" code

This trigger does not work as the function is not set up properly

A trigger must always be implemented with a function

A function can only be used with a trigger