[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 04/12: upgrade102 Adapt for postgres 9.0
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 04/12: upgrade102 Adapt for postgres 9.0 |
Date: |
Fri, 16 Mar 2018 16:28:26 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit d6464a1e8df80da7c2be2005602a6cf9501ce56a
Author: Dany De Bontridder <address@hidden>
Date: Thu Mar 15 10:17:44 2018 +0100
upgrade102 Adapt for postgres 9.0
---
include/sql/patch/upgrade102.sql | 12 ++++++------
1 file changed, 6 insertions(+), 6 deletions(-)
diff --git a/include/sql/patch/upgrade102.sql b/include/sql/patch/upgrade102.sql
index 9319d51..1271508 100644
--- a/include/sql/patch/upgrade102.sql
+++ b/include/sql/patch/upgrade102.sql
@@ -1,7 +1,7 @@
begin;
CREATE OR REPLACE FUNCTION comptaproc.check_balance(p_grpt integer)
RETURNS numeric AS
-$BODY$
+$_$
declare
amount_jrnx_debit numeric;
amount_jrnx_credit numeric;
@@ -34,8 +34,8 @@ begin
end if;
return 0;
end;
-$BODY$
- LANGUAGE plpgsql;
+$_$
+LANGUAGE plpgsql;
update op_predef set od_direct='t' where od_jrn_type='ODS';
@@ -150,7 +150,7 @@ CREATE INDEX link_action_type_fki
-- Trigger: trg_action_gestion_related on action_gestion_related
CREATE OR REPLACE FUNCTION comptaproc.action_gestion_related_ins_up()
RETURNS trigger AS
-$BODY$
+$_$
declare
nTmp bigint;
begin
@@ -168,8 +168,8 @@ end if;
return NEW;
end;
-$BODY$
- LANGUAGE plpgsql ;
+$_$
+ LANGUAGE plpgsql;
-- DROP TRIGGER trg_action_gestion_related ON action_gestion_related;
CREATE TRIGGER trg_action_gestion_related
- [Noalyss-commit] [noalyss] branch master updated (2711cee -> 5ae4416), Dany De Bontridder, 2018/03/16
- [Noalyss-commit] [noalyss] 02/12: Install.php, Dany De Bontridder, 2018/03/16
- [Noalyss-commit] [noalyss] 04/12: upgrade102 Adapt for postgres 9.0,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 05/12: Fix problem with old SQL upgrade, Dany De Bontridder, 2018/03/16
- [Noalyss-commit] [noalyss] 03/12: Improve MONO, Dany De Bontridder, 2018/03/16
- [Noalyss-commit] [noalyss] 06/12: Fix version for MONO, Dany De Bontridder, 2018/03/16
- [Noalyss-commit] [noalyss] 10/12: Upgrade : do not propose to upgrade if system up to date, Dany De Bontridder, 2018/03/16
- [Noalyss-commit] [noalyss] 07/12: translation, Dany De Bontridder, 2018/03/16
- [Noalyss-commit] [noalyss] 12/12: Improve install, Dany De Bontridder, 2018/03/16
- [Noalyss-commit] [noalyss] 11/12: Improve calc, Dany De Bontridder, 2018/03/16
- [Noalyss-commit] [noalyss] 09/12: translate, Dany De Bontridder, 2018/03/16
- [Noalyss-commit] [noalyss] 08/12: translate, Dany De Bontridder, 2018/03/16
- [Noalyss-commit] [noalyss] 01/12: Translate, Dany De Bontridder, 2018/03/16