Changes between Version 3 and Version 4 of Advanced Database Development

Timestamp:

02/10/26 15:28:19 (3 weeks ago)

Author:

231035

Comment:

--

Advanced Database Development

@@ -455 +455 @@
 
 }}}
-{{{Stored procedures}}}
-{{{
-CREATE OR REPLACE PROCEDURE petify_soft_delete_review(p_review_id bigint)
-LANGUAGE plpgsql
-AS $$
-BEGIN
- 
-  PERFORM set_config('session_replication_role', 'replica', true);
-
-  UPDATE reviews
-  SET is_deleted = true,
-      updated_at = now()
-  WHERE review_id = p_review_id;
-
-  PERFORM set_config('session_replication_role', 'origin', true);
-END;
-$$;
-
-}}}
 {{{Views}}}
 {{{
@@ -494 +475 @@
 GROUP BY cr.target_clinic_id;
 }}}
-{{{Custom domains}}
+{{{Custom domains}}}
 {{{
 CREATE DOMAIN rating_1_5 AS int CHECK (VALUE BETWEEN 1 AND 5);