Author: danydb Date: 2013-10-23 21:19:57 +0200 (Wed, 23 Oct 2013) New Revision: 549
Modified: trunk/ trunk/rapport_avance/sql/upgrade4.sql Log: Merged revisions 548 via svnmerge from svn+ssh://[email protected]/svn_extension/tag/rel700 ........ r548 | danydb | 2013-10-23 21:19:05 +0200 (mer., 23 oct. 2013) | 2 lines rapav: Correct script upgrade ........ Property changes on: trunk ___________________________________________________________________ Name: svnmerge-integrated - /tag/rel700:1-546 + /tag/rel700:1-548 Modified: trunk/rapport_avance/sql/upgrade4.sql =================================================================== --- trunk/rapport_avance/sql/upgrade4.sql 2013-10-23 19:19:05 UTC (rev 548) +++ trunk/rapport_avance/sql/upgrade4.sql 2013-10-23 19:19:57 UTC (rev 549) @@ -3,7 +3,7 @@ ALTER TABLE rapport_advanced.formulaire_param_detail ADD COLUMN jrn_def_id bigint; COMMENT ON COLUMN rapport_advanced.formulaire_param_detail.jrn_def_id IS 'FK to jrn_def, if null then all the ledgers are concerned'; -CREATE FUNCTION formulaire_param_detail_jrn_def_id_ins_upd() RETURNS trigger +CREATE FUNCTION rapport_advanced.formulaire_param_detail_jrn_def_id_ins_upd() RETURNS trigger AS $$ declare jrn_def_id integer; @@ -13,7 +13,8 @@ NEW.jrn_def_id := jrn_def_id; end if; return NEW; -end;$$; +end; +$$ language plpgsql; CREATE INDEX fki_jrn_def_id ON rapport_advanced.formulaire_param_detail USING btree (jrn_def_id); --- PhpCompta est un logiciel de comptabilité libre en ligne (full web) Projet opensource http://www.phpcompta.eu _______________________________________________ Phpcompta est un logiciel libre de comptabilité en ligne (http://www.phpcompta.eu) Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
