Changes between Version 21 and Version 22 of DatabaseProgramming

Timestamp:

06/15/26 12:00:29 (2 days ago)

Author:

231072

Comment:

--

DatabaseProgramming

@@ -645 +645 @@
 
 {{{
-CREATE OR REPLACE FUNCTION trg_prevent_over_selling()
+CREATE OR REPLACE FUNCTION fn_prevent_over_selling()
 RETURNS TRIGGER
 LANGUAGE plpgsql
@@ -653 +653 @@
 BEGIN
 
-    
+ 
     SELECT quantity
     INTO v_stock
@@ -659 +659 @@
     WHERE product_id = NEW.product_id;
 
-    
+   
     IF NOT FOUND THEN
         RAISE EXCEPTION 'Product % does not exist', NEW.product_id;
     END IF;
 
-    
+   
     IF v_stock < NEW.quantity THEN
         RAISE EXCEPTION
@@ -674 +674 @@
 END;
 $$;
-}}}
+
+
+CREATE TRIGGER trg_prevent_over_selling
+BEFORE INSERT ON orderitems
+FOR EACH ROW
+EXECUTE FUNCTION fn_prevent_over_selling();
+}}}