Fixing triggers

1 files changed, 3 insertions, 4 deletions

diff --git a/notes/projects/radius/sql/ippool-schema.sql b/notes/projects/radius/sql/ippool-schema.sql
index fcf74ea..3730051 100644
--- a/notes/projects/radius/sql/ippool-schema.sql
+++ b/notes/projects/radius/sql/ippool-schema.sql
@@ -246,10 +246,10 @@ BEGIN
 
    -- verifies ip is not assigned to a RADIUS accounting session
    IF ( OLD.nasId IS NOT NULL ) THEN
-      RAISE EXCEPTION 'IP address is still assigned to NAS session';
+      RETURN NULL;
    END IF;
 
-   RETURN NEW;
+   RETURN OLD;
 END;
 $$;
 
@@ -285,8 +285,7 @@ CREATE OR REPLACE FUNCTION ip_trigger_truncate
    AS               $$
 DECLARE
 BEGIN
-   RAISE EXCEPTION 'DO NOT TRUNCATE IP TABLE';
-   RETURN NEW;
+   RETURN NULL;
 END;
 $$;