Changes between Version 4 and Version 5 of Triggers

Timestamp:

08/25/25 17:16:26 (8 days ago)

Author:

221007

Comment:

--

Triggers

@@ -271 +271 @@
 
 {{{
-CREATE OR REPLACE FUNCTION validate_embg_format()
-RETURNS TRIGGER AS $$
+create function validate_embg_format() returns trigger
+    language plpgsql
+as
+$$
 DECLARE
     date_part TEXT;
     gender_code TEXT;
 BEGIN
+    IF COALESCE(NEW.is_stub, false) THEN
+        RETURN NEW;
+    END IF;
     date_part := TO_CHAR(NEW.date_of_birth, 'DD')
         || TO_CHAR(NEW.date_of_birth, 'MM')
@@ -293 +298 @@
     RETURN NEW;
 END;
-$$ LANGUAGE plpgsql;
-
-CREATE TRIGGER check_embg_format
-BEFORE INSERT OR UPDATE ON Person
+$$;
+
+CREATE TRIGGER trg_validate_embg
+BEFORE INSERT OR UPDATE ON person
 FOR EACH ROW
 EXECUTE FUNCTION validate_embg_format();