[Noalyss-commit] [noalyss] 249/323: SQL Patch : correct syntax for new version

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 135a17ac1d0924458f7cbcee1bd41b25ca51b701
Author: Dany De Bontridder <address@hidden>
Date:   Sat Feb 24 13:16:00 2018 +0100

    SQL Patch : correct syntax for new version
---
 include/sql/patch/upgrade10.sql  | 2 +-
 include/sql/patch/upgrade102.sql | 2 +-
 include/sql/patch/upgrade107.sql | 2 +-
 include/sql/patch/upgrade11.sql  | 6 +++---
 include/sql/patch/upgrade120.sql | 2 +-
 include/sql/patch/upgrade121.sql | 2 +-
 include/sql/patch/upgrade13.sql  | 2 +-
 include/sql/patch/upgrade9.sql   | 6 +++---
 include/sql/patch/upgrade97.sql  | 3 ++-
 9 files changed, 14 insertions(+), 13 deletions(-)

diff --git a/include/sql/patch/upgrade10.sql b/include/sql/patch/upgrade10.sql
index 000d21a..8d98c2d 100644
--- a/include/sql/patch/upgrade10.sql
+++ b/include/sql/patch/upgrade10.sql
@@ -18,7 +18,7 @@ begin
        end if;
 end;
 $BODY$
-  LANGUAGE plpgsql VOLATILE;
+  LANGUAGE plpgsql;
 
 
 -- Function: check_balance(p_grpt text)
diff --git a/include/sql/patch/upgrade102.sql b/include/sql/patch/upgrade102.sql
index 2e4d25d..9319d51 100644
--- a/include/sql/patch/upgrade102.sql
+++ b/include/sql/patch/upgrade102.sql
@@ -372,7 +372,7 @@ begin
 return NEW;
 end;
 $BODY$
-  LANGUAGE plpgsql VOLATILE;
+  LANGUAGE plpgsql;
 
 
 CREATE TRIGGER fiche_detail_upd_trg   BEFORE UPDATE   ON fiche_detail   FOR 
EACH ROW   EXECUTE PROCEDURE comptaproc.fiche_detail_qcode_upd();
diff --git a/include/sql/patch/upgrade107.sql b/include/sql/patch/upgrade107.sql
index fa89168..c1c41b3 100644
--- a/include/sql/patch/upgrade107.sql
+++ b/include/sql/patch/upgrade107.sql
@@ -259,7 +259,7 @@ $BODY$
        end;
 $BODY$
 
-LANGUAGE plpgsql VOLATILE;
+LANGUAGE plpgsql;
 
 alter table op_predef add od_description text;
 create or replace function comptaproc.opd_limit_description() 
diff --git a/include/sql/patch/upgrade11.sql b/include/sql/patch/upgrade11.sql
index ce2e89b..22c006c 100644
--- a/include/sql/patch/upgrade11.sql
+++ b/include/sql/patch/upgrade11.sql
@@ -34,7 +34,7 @@ begin
        return;
 end;
 $BODY$ 
-LANGUAGE plpgsql VOLATILE;
+LANGUAGE plpgsql;
 
 -- Function: tva_insert(int4, text, numeric, text, text)
 
@@ -79,7 +79,7 @@ insert into 
tva_rate(tva_id,tva_label,tva_rate,tva_comment,tva_poste)
 return 0;
 end;
 $BODY$
-LANGUAGE plpgsql VOLATILE;
+LANGUAGE plpgsql;
 
 -- Function: tva_insert(p_tva_id text, p_tva_label text, p_tva_rate text, 
p_tva_comment text, p_tva_poste text)
 
@@ -119,7 +119,7 @@ update tva_rate set 
tva_label=p_tva_label,tva_rate=p_tva_rate,tva_comment=p_tva_
 return 0;
 end;
 $BODY$
-LANGUAGE plpgsql VOLATILE;
+LANGUAGE plpgsql;
 
 
 update version set val=12;
diff --git a/include/sql/patch/upgrade120.sql b/include/sql/patch/upgrade120.sql
index 1eb7daf..9c9cca5 100644
--- a/include/sql/patch/upgrade120.sql
+++ b/include/sql/patch/upgrade120.sql
@@ -237,7 +237,7 @@ loop
 return;
 end;
 $BODY$
-  LANGUAGE plpgsql ;
+LANGUAGE plpgsql;
 
 DROP FUNCTION comptaproc.get_menu_tree(text, text);
 
diff --git a/include/sql/patch/upgrade121.sql b/include/sql/patch/upgrade121.sql
index efcbc56..1804884 100644
--- a/include/sql/patch/upgrade121.sql
+++ b/include/sql/patch/upgrade121.sql
@@ -303,7 +303,7 @@ begin
        
 end;
 $BODY$
-LANGUAGE plpgsql ;
+LANGUAGE plpgsql;
 
 
 delete from profile_menu where pm_id_dep is not null and pm_id_dep not  in 
(select pm_id from profile_menu);
diff --git a/include/sql/patch/upgrade13.sql b/include/sql/patch/upgrade13.sql
index 9a3343d..4682b78 100644
--- a/include/sql/patch/upgrade13.sql
+++ b/include/sql/patch/upgrade13.sql
@@ -175,7 +175,7 @@ raise debug 'nNew %', nNew;
 return 0;
 end;
 $BODY$
-  LANGUAGE 'plpgsql' VOLATILE;
+  LANGUAGE plpgsql;
 
 create or replace function account_parent(p_account tmp_pcmn.pcm_val%type)
 returns 
diff --git a/include/sql/patch/upgrade9.sql b/include/sql/patch/upgrade9.sql
index 634e8b2..0d32207 100644
--- a/include/sql/patch/upgrade9.sql
+++ b/include/sql/patch/upgrade9.sql
@@ -133,7 +133,7 @@ CREATE OR REPLACE FUNCTION update_quick_code(njft_id 
int4,tav_text text)
        return ns;
        end;
 $BODY$
-  LANGUAGE plpgsql VOLATILE;
+  LANGUAGE plpgsql;
 
 
 
@@ -186,7 +186,7 @@ begin
        return;
 end;   
 $body$
-  LANGUAGE plpgsql VOLATILE;
+  LANGUAGE plpgsql;
 
 
 
@@ -228,7 +228,7 @@ CREATE OR REPLACE FUNCTION insert_quick_code(nf_id int4, 
tav_text text)
        return ns;
        end;
 $BODY$
-  LANGUAGE plpgsql VOLATILE;
+  LANGUAGE plpgsql;
 
 
 
diff --git a/include/sql/patch/upgrade97.sql b/include/sql/patch/upgrade97.sql
index f2232ab..3d5e049 100644
--- a/include/sql/patch/upgrade97.sql
+++ b/include/sql/patch/upgrade97.sql
@@ -748,7 +748,8 @@ loop
        end loop;
 return;
 end;
-$BODY$ language plpgsql;
+$BODY$ 
+language plpgsql;