[Noalyss-commit] [noalyss] branch master updated: Fix bug for old version

[Dany De Bontridder]

This is an automated email from the git hooks/post-receive script.

sparkyx pushed a commit to branch master
in repository noalyss.

The following commit(s) were added to refs/heads/master by this push:
     new 135deaf  Fix bug for old version
135deaf is described below

commit 135deaf60a8961fcffcaa3d4669695875aa7d93f
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Wed Dec 8 21:56:09 2021 +0100

    Fix bug for old version
---
 include/sql/patch/upgrade171.sql | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/include/sql/patch/upgrade171.sql b/include/sql/patch/upgrade171.sql
index d3f3f69..9a0dbf4 100644
--- a/include/sql/patch/upgrade171.sql
+++ b/include/sql/patch/upgrade171.sql
@@ -1,7 +1,10 @@
 begin;
 ALTER TABLE public.parm_periode ADD p_exercice_label text NULL;
 COMMENT ON COLUMN public.parm_periode.p_exercice_label IS 'label of the 
exercice';
+alter table parm_periode disable trigger parm_periode_check_periode_trg;
+
 update parm_periode set p_exercice_label =p_exercice ;
+alter table parm_periode enable trigger parm_periode_check_periode_trg;
 ALTER TABLE public.parm_periode ALTER COLUMN p_exercice_label SET NOT NULL;
 
 COMMENT ON COLUMN public.parm_periode.p_start IS 'Start date of periode';
@@ -46,4 +49,4 @@ LANGUAGE plpgsql;
 
 
 insert into version (val,v_description) values (172,'Add free label for 
exercice');
-commit;
\ No newline at end of file
+commit;