Changes between Version 2 and Version 3 of Advanced Database Development

Timestamp:

02/10/26 15:27:25 (3 weeks ago)

Author:

231035

Comment:

--

Advanced Database Development

@@ -324 +324 @@
 EXECUTE FUNCTION petify_trg_reviews_no_update();
 
-RETURNS trigger
-LANGUAGE plpgsql
-AS $$
-BEGIN
-  RAISE EXCEPTION 'Reviews cannot be deleted directly. Use the soft-delete procedure.';
-END;
-$$;
-
-DROP TRIGGER IF EXISTS trg_reviews_no_delete ON reviews;
-CREATE TRIGGER trg_reviews_no_delete
-BEFORE DELETE
-ON reviews
-FOR EACH ROW
-EXECUTE FUNCTION petify_trg_reviews_no_delete();
-
-CREATE OR REPLACE FUNCTION petify_trg_no_update_generic()
-RETURNS trigger
-LANGUAGE plpgsql
-AS $$
-BEGIN
-  RAISE EXCEPTION 'Updates are not allowed on this table.';
-END;
-$$;
-
-DROP TRIGGER IF EXISTS trg_user_reviews_no_update ON user_reviews;
-CREATE TRIGGER trg_user_reviews_no_update
-BEFORE UPDATE
-ON user_reviews
-FOR EACH ROW
-EXECUTE FUNCTION petify_trg_no_update_generic();
-
 DROP TRIGGER IF EXISTS trg_clinic_reviews_no_update ON clinic_reviews;
 CREATE TRIGGER trg_clinic_reviews_no_update