Changes between Version 7 and Version 8 of AdvancedDatabaseDevelopment

Timestamp:

02/20/26 05:31:41 (4 days ago)

Author:

221181

Comment:

--

AdvancedDatabaseDevelopment

@@ -69 +69 @@
 
 {{{#!sql
-CREATE OR REPLACE FUNCTION trg_fn_no_self_delete()
-RETURNS TRIGGER
-LANGUAGE plpgsql
-AS $$
+CREATE OR REPLACE FUNCTION stock_management.prevent_self_delete()
+RETURNS TRIGGER AS $$
 BEGIN
-    IF OLD.username = CURRENT_USER THEN
+    IF OLD.username = current_setting('app.current_user', true) THEN
         RAISE EXCEPTION 'You cannot delete your own account.';
     END IF;
     RETURN OLD;
 END;
-$$;
+$$ LANGUAGE plpgsql;
 
-CREATE TRIGGER trg_no_self_delete
-BEFORE DELETE ON users
-FOR EACH ROW
-EXECUTE FUNCTION trg_fn_no_self_delete();
+CREATE OR REPLACE TRIGGER trg_prevent_self_delete
+BEFORE DELETE ON stock_management.users
+FOR EACH ROW EXECUTE FUNCTION stock_management.prevent_self_delete();
 }}}