[Noalyss-commit] [noalyss] 01/04: Bug : patch 116 , le trigger invalide à cause changement type de col dans la même transaction

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit e81b7641d1115e8152418a40e267c8b288dffb17
Author: Dany De Bontridder <address@hidden>
Date:   Tue Dec 15 04:35:59 2015 +0100

    Bug : patch 116 , le trigger invalide à cause changement type de col dans 
la même transaction
---
 include/sql/patch/upgrade116.sql |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/include/sql/patch/upgrade116.sql b/include/sql/patch/upgrade116.sql
index 4d3f98c..c7937cb 100644
--- a/include/sql/patch/upgrade116.sql
+++ b/include/sql/patch/upgrade116.sql
@@ -18,8 +18,7 @@ end;
 $function$
  language plpgsql;
 
--- bug 
-alter table action_gestion alter ag_title type text;
+
 
 INSERT INTO menu_ref(me_code, me_menu, me_file,   
me_type,me_description_etendue)VALUES ('ANCKEY', 'Clef de répartition',  
'anc_key.inc.php','ME','Permet de gèrer les clefs de répartition en 
comptabilité analytique');
 
@@ -216,7 +215,8 @@ CREATE TRIGGER trg_category_card_before_delete
   ON fiche_def
   FOR EACH ROW
   EXECUTE PROCEDURE comptaproc.category_card_before_delete();
-
+-- bug 
+alter table action_gestion alter ag_title type text;
 alter table action_gestion add constraint fk_action_gestion_document_type 
foreign key (ag_type) references document_type(dt_id);