From 23fd077da11b254de32bf1cfaf7cebced03aa0d5 Mon Sep 17 00:00:00 2001 From: Jean-Marc Pigeon Date: Fri, 14 Nov 2025 10:36:58 -0500 Subject: [PATCH] Fixing trigger syntaxe --- sql/mailleur.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/mailleur.sql b/sql/mailleur.sql index 0447e8d..629c1bb 100644 --- a/sql/mailleur.sql +++ b/sql/mailleur.sql @@ -177,7 +177,7 @@ CREATE FUNCTION updpass() RETURNS trigger AS $$ DECLARE skip BOOLEAN := FALSE; BEGIN - SELECT skip_password_triggerINTO skip + SELECT skip_password_trigger INTO skip FROM temp_skip_flag limit 1; IF skip = FALSE THEN NEW.hash = md5(HASHING); -- 2.47.3