[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 249/323: SQL Patch : correct syntax for new v
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 249/323: SQL Patch : correct syntax for new version |
Date: |
Wed, 14 Mar 2018 17:38:59 -0400 (EDT) |
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;
- [Noalyss-commit] [noalyss] 211/323: sorttable.js : Add an icon if the column is already sorted, (continued)
- [Noalyss-commit] [noalyss] 211/323: sorttable.js : Add an icon if the column is already sorted, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 196/323: Fix SQL, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 227/323: patch sql : remove commented code, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 225/323: Dashboard : Fix box, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 181/323: Task #0001535: TVA : réécriture du module CFGTVA, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 183/323: Task #0001536: Achat - Vente : n'utilisez que les codes TVA disponibles, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 215/323: Plugin : fix doc, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 213/323: Plugin : fix indent, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 234/323: Fix warning, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 230/323: index.css : CSS responsive, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 249/323: SQL Patch : correct syntax for new version,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 252/323: PLANANC : fix bug when creating first plan, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 226/323: Dashboard : remove dead code, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 217/323: Periode : fix bug, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 208/323: Missing file, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 233/323: Backward comptability for SQL function, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 264/323: Category Aged Balance add a start date, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 269/323: typo, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 270/323: check if open_basedir is empty, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 170/323: indent, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 207/323: Missing file, Dany De Bontridder, 2018/03/14