| 310 | | CREATE OR REPLACE FUNCTION petify_trg_reviews_no_update() |
| 311 | | RETURNS trigger |
| 312 | | LANGUAGE plpgsql |
| 313 | | AS $$ |
| 314 | | BEGIN |
| 315 | | RAISE EXCEPTION 'Reviews are immutable. Updates are not allowed (review_id=%).', OLD.review_id; |
| 316 | | END; |
| 317 | | $$; |
| 318 | | |
| 319 | | DROP TRIGGER IF EXISTS trg_reviews_no_update ON reviews; |
| 320 | | CREATE TRIGGER trg_reviews_no_update |
| 321 | | BEFORE UPDATE |
| 322 | | ON reviews |
| 323 | | FOR EACH ROW |
| 324 | | EXECUTE FUNCTION petify_trg_reviews_no_update(); |
| 325 | | |
| 326 | | DROP TRIGGER IF EXISTS trg_clinic_reviews_no_update ON clinic_reviews; |
| 327 | | CREATE TRIGGER trg_clinic_reviews_no_update |
| 328 | | BEFORE UPDATE |
| 329 | | ON clinic_reviews |
| 330 | | FOR EACH ROW |
| 331 | | EXECUTE FUNCTION petify_trg_no_update_generic(); |
| 332 | | |
