[Noalyss-commit] [noalyss] 03/10: QCODE : remove trigger update on jrnx

[dwm]

sparkyx pushed a commit to branch devel
in repository noalyss.

commit b5213f3308d1776fbaaa2b625ad5b316af4826cc
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Mon Feb 19 16:33:40 2024 +0100

    QCODE : remove trigger update on jrnx
---
 sql/reverse.sql | 2 ++
 sql/upgrade.sql | 1 +
 2 files changed, 3 insertions(+)

diff --git a/sql/reverse.sql b/sql/reverse.sql
index 8b1378917..351d24900 100644
--- a/sql/reverse.sql
+++ b/sql/reverse.sql
@@ -1 +1,3 @@
 
+create trigger t_jrnx_upd before update on
+    public.jrnx for each row execute function jrnx_ins();
\ No newline at end of file
diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index e69de29bb..0e7d7a6d5 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -0,0 +1 @@
+DROP TRIGGER t_jrnx_upd ON public.jrnx;