[Noalyss-commit] [noalyss] 11/20: remove raise

[dwm]

sparkyx pushed a commit to branch master
in repository noalyss.

commit a810c80cd7d22cfad13d379f16bcd22dc8dd9258
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Tue Dec 5 14:03:25 2023 +0100

    remove raise
---
 sql/upgrade.sql | 7 +++----
 1 file changed, 3 insertions(+), 4 deletions(-)

diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index 6f660fa2c..c1b424bb5 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -10,15 +10,11 @@ declare
        i record;
 begin
        if NEW.ad_id=23 and NEW.ad_value != OLD.ad_value then
-               RAISE NOTICE 'new qcode [%] old qcode 
[%]',NEW.ad_value,OLD.ad_value;
                update jrnx set j_qcode=NEW.ad_value where j_qcode = 
OLD.ad_value;
                update op_predef_detail set opd_poste=NEW.ad_value where 
opd_poste=OLD.ad_value;
-               raise notice 'TRG fiche_detail update op_predef_detail set 
opd_poste=% where opd_poste=%;',NEW.ad_value,OLD.ad_value;
                for i in select ad_id from attr_def where ad_type = 'card' or 
ad_id=25 loop
                        update fiche_detail set ad_value=NEW.ad_value where 
ad_value=OLD.ad_value and ad_id=i.ad_id;
-                       RAISE NOTICE 'change for ad_id [%] ',i.ad_id;
                        if i.ad_id=19 then
-                               RAISE NOTICE 'Change in stock_goods OLD[%] by 
NEW[%]',OLD.ad_value,NEW.ad_value;
                                update stock_goods set sg_code=NEW.ad_value 
where sg_code=OLD.ad_value;
                        end if;
 
@@ -30,6 +26,7 @@ $function$
 ;
 
 drop trigger if exists fiche_detail_check_qcode_trg on public.fiche_detail ;
+drop function  comptaproc.fiche_detail_qcode_upd();
 
 create trigger fiche_detail_check_qcode_trg before insert
 or update on
@@ -38,3 +35,5 @@ public.fiche_detail for each row execute function 
comptaproc.fiche_detail_check_
 
 
 update fiche_detail set ad_value=ad_value where ad_id in (select ad_id from 
attr_def where ad_type='card');
+
+