[Noalyss-commit] [noalyss] 05/323: Fix : script failed due to the lack of search_path

[Dany De Bontridder]

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';