[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 05/323: Fix : script failed due to the lack o
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 05/323: Fix : script failed due to the lack of search_path |
Date: |
Wed, 14 Mar 2018 17:38:08 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit b68cb572219baf7dfeb108291e362f0e76b29b3f
Author: Dany De Bontridder <address@hidden>
Date: Tue Dec 19 12:38:17 2017 +0100
Fix : script failed due to the lack of search_path
---
sql/upgrade.sql | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index 879e934..d8ff69b 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -1,3 +1,4 @@
+set search_path=public,comptaproc;
alter table action_gestion drop ag_ref_ag_id;
@@ -16,7 +17,7 @@ ALTER TABLE tmp_pcmn ALTER COLUMN id SET NOT NULL;
ALTER TABLE tmp_pcmn ALTER COLUMN id SET DEFAULT
nextval('tmp_pcmn_id_seq'::regclass);
ALTER TABLE tmp_pcmn ADD CONSTRAINT id_ux UNIQUE(id);
COMMENT ON COLUMN tmp_pcmn.id IS 'allow to identify the row, it is unique and
not null (pseudo pk)';
-
+update tmp_pcmn set id=nextval('tmp_pcmn_id_seq');
-- set search_path to public,comptaproc;
alter table tmp_pcmn add column pcm_direct_use varchar(1);
COMMENT ON COLUMN tmp_pcmn.pcm_direct_use IS 'Value are N or Y , N cannot be
used directly , not even through a card';
- [Noalyss-commit] [noalyss] 02/323: script.js : code cleaning, (continued)
- [Noalyss-commit] [noalyss] 02/323: script.js : code cleaning, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 01/323: Fix problem with invalid unicode sequence, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 06/323: Fix : is now protected instead of private, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 09/323: Data_SQL : add doxygen doc, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 08/323: Data_SQL : add doxygen doc, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 07/323: Acc_Plan_MTable : add doxygen doc, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 11/323: redirect incorrect : fix small bug, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 13/323: Add Documentation, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 18/323: cosmetic , add a button close for warning, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 17/323: query is prepared twice and cannot be called only once, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 05/323: Fix : script failed due to the lack of search_path,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 10/323: Acc_Plan_SQL : add doxygen doc, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 14/323: Update Doxyfile : version nb, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 15/323: Fix problem with font OpenSans, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 19/323: Task #1516 : Module période : add icon for closing / opening, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 12/323: Rewriting periode : add format date + exception, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 24/323: use calcy instead of computing the scroll, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 20/323: Add documentation , code rewriting : use of title_box, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 25/323: Task#1461 : nombre de fiches dans catégorie, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 27/323: set_jrn in deprecated and replaced by set_ledger, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 22/323: code rewriting : use of title_box + button close for Card Detail, Dany De Bontridder, 2018/03/14