Changes between Version 5 and Version 6 of AdvancedDatabaseDevelopment

Timestamp:

02/20/26 02:59:14 (4 days ago)

Author:

221181

Comment:

--

AdvancedDatabaseDevelopment

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