Reinstallation fraiche donne une db incomplète #20

• suivi les instructions du README
• le vendro se met bien à la version (mais la branche est détachée)
    ◦ julien@supertramp:/mnt/tera/ChampsLibres/Projets/BiomMap/repo/biommap/vendor/GeoNature-citizen$ git status
    ◦ HEAD detached at c5f36d3
    ◦ nothing to commit, working tree clean
• docker-compose up
    ◦ les conteneurs se crée très vite, car les images existent par ailleurs
• build du frontend :ok
• problème l’app ne marche pas car il manque plusieurs tables !!!!
    ◦ manque plusieurs table dans gnc_core, manque schema gnc_obstax, gnc_sites!

Il faudrait:

essayer en rebuildant les images
essayer avec un état ancien des branches

log installation

2021-09-15 11:49:30.942 UTC [35] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1             | 2021-09-15 11:49:30.954 UTC [36] LOG:  database system was shut down at 2021-09-15 11:49:30 UTC
db_1             | 2021-09-15 11:49:30.957 UTC [35] LOG:  database system is ready to accept connections
db_1             |  done
db_1             | server started
db_1             | 
db_1             | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/10_postgis.sh
db_1             | CREATE DATABASE
db_1             | Loading PostGIS extensions into template_postgis
db_1             | CREATE EXTENSION
db_1             | CREATE EXTENSION
db_1             | CREATE EXTENSION
db_1             | CREATE EXTENSION
db_1             | Loading PostGIS extensions into postgres
db_1             | CREATE EXTENSION
db_1             | CREATE EXTENSION
db_1             | CREATE EXTENSION
db_1             | CREATE EXTENSION
db_1             | 
db_1             | waiting for server to shut down....2021-09-15 11:49:34.042 UTC [35] LOG:  received fast shutdown request
db_1             | 2021-09-15 11:49:34.043 UTC [35] LOG:  aborting any active transactions
db_1             | 2021-09-15 11:49:34.043 UTC [35] LOG:  background worker "logical replication launcher" (PID 42) exited with exit code 1
db_1             | 2021-09-15 11:49:34.045 UTC [37] LOG:  shutting down
db_1             | 2021-09-15 11:49:34.115 UTC [35] LOG:  database system is shut down
db_1             |  done
db_1             | server stopped
db_1             | 
db_1             | PostgreSQL init process complete; ready for start up.
db_1             | 
db_1             | 2021-09-15 11:49:34.154 UTC [1] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
db_1             | 2021-09-15 11:49:34.154 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
db_1             | 2021-09-15 11:49:34.154 UTC [1] LOG:  listening on IPv6 address "::", port 5432
db_1             | 2021-09-15 11:49:34.157 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1             | 2021-09-15 11:49:34.178 UTC [54] LOG:  database system was shut down at 2021-09-15 11:49:34 UTC
db_1             | 2021-09-15 11:49:34.183 UTC [1] LOG:  database system is ready to accept connections
db_1             | 2021-09-15 11:50:10.593 UTC [84] ERROR:  schema "taxonomie" already exists
db_1             | 2021-09-15 11:50:10.593 UTC [84] STATEMENT:  CREATE SCHEMA taxonomie;
db_1             | 2021-09-15 11:50:37.845 UTC [88] ERROR:  operator class "gist_trgm_ops" does not exist for access method "gist"
db_1             | 2021-09-15 11:50:37.845 UTC [88] STATEMENT:  CREATE INDEX i_tri_vm_taxref_list_forautocomplete_search_name
db_1             | 	  ON vm_taxref_list_forautocomplete
db_1             | 	  USING gist
db_1             | 	  (search_name  gist_trgm_ops);
db_1             | 2021-09-15 11:50:38.019 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.019 UTC [91] DETAIL:  Key (cd_nom)=(67111) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.019 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (67111, 67111, 'Ablette');
db_1             | 2021-09-15 11:50:38.019 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.019 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.019 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.020 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.020 UTC [91] DETAIL:  Key (cd_nom)=(60612) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.020 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (60612, 60612, 'Lynx boréal');
db_1             | 2021-09-15 11:50:38.020 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.020 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.020 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.021 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.021 UTC [91] DETAIL:  Key (cd_nom)=(351) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.021 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (351, 351, 'Grenouille rousse');
db_1             | 2021-09-15 11:50:38.021 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.021 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.021 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.021 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.021 UTC [91] DETAIL:  Key (cd_nom)=(8326) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.021 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (8326, 8326, 'Cicindèle hybride');
db_1             | 2021-09-15 11:50:38.021 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.021 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.021 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.022 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.022 UTC [91] DETAIL:  Key (cd_nom)=(11165) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.022 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (11165, 11165, 'Coccinelle à 7 points');
db_1             | 2021-09-15 11:50:38.022 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.022 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.022 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.022 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.022 UTC [91] DETAIL:  Key (cd_nom)=(18437) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.022 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (18437, 18437, 'Ecrevisse à pieds blancs');
db_1             | 2021-09-15 11:50:38.023 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.023 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.023 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.023 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.023 UTC [91] DETAIL:  Key (cd_nom)=(81065) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.023 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (81065, 81065, 'Alchémille rampante');
db_1             | 2021-09-15 11:50:38.023 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.023 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.023 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.023 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.023 UTC [91] DETAIL:  Key (cd_nom)=(95186) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.023 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (95186, 95186, 'Inule fétide');
db_1             | 2021-09-15 11:50:38.024 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.024 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.024 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.024 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.024 UTC [91] DETAIL:  Key (cd_nom)=(713776) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.024 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais, comments) VALUES (713776, 209902, '-', 'un synonyme');
db_1             | 2021-09-15 11:50:39.345 UTC [92] ERROR:  function public.uuid_generate_v4() does not exist at character 146
db_1             | 2021-09-15 11:50:39.345 UTC [92] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
db_1             | 2021-09-15 11:50:39.345 UTC [92] STATEMENT:  CREATE TABLE IF NOT EXISTS t_roles (
db_1             | 	    groupe boolean DEFAULT false NOT NULL,
db_1             | 	    id_role serial NOT NULL,
db_1             | 	    uuid_role uuid NOT NULL DEFAULT public.uuid_generate_v4(),
db_1             | 	    identifiant character varying(100),
db_1             | 	    nom_role character varying(50),
db_1             | 	    prenom_role character varying(50),
db_1             | 	    desc_role text,
db_1             | 	    pass character varying(100),
db_1             | 	    pass_plus text,
db_1             | 	    email character varying(250),
db_1             | 	    id_organisme integer,
db_1             | 	    remarques text,
db_1             | 	    active boolean DEFAULT true,
db_1             | 	    champs_addi jsonb,
db_1             | 	    date_insert timestamp without time zone,
db_1             | 	    date_update timestamp without time zone
db_1             | 	);
db_1             | 2021-09-15 11:50:39.346 UTC [92] ERROR:  function public.uuid_generate_v4() does not exist at character 120
db_1             | 2021-09-15 11:50:39.346 UTC [92] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
db_1             | 2021-09-15 11:50:39.346 UTC [92] STATEMENT:  CREATE TABLE IF NOT EXISTS bib_organismes (
nginx_1          | /docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh
db_1             | 	    id_organisme serial NOT NULL,
db_1             | 	    uuid_organisme uuid NOT NULL DEFAULT public.uuid_generate_v4(),
db_1             | 	    nom_organisme character varying(100) NOT NULL,
db_1             | 	    adresse_organisme character varying(128),
db_1             | 	    cp_organisme character varying(5),
db_1             | 	    ville_organisme character varying(100),
db_1             | 	    tel_organisme character varying(14),
db_1             | 	    fax_organisme character varying(14),
db_1             | 	    email_organisme character varying(100),
db_1             | 	    url_organisme character varying(255),
db_1             | 	    url_logo character varying(255),
db_1             | 	    id_parent integer
db_1             | 	);
db_1             | 2021-09-15 11:50:39.369 UTC [92] ERROR:  relation "bib_organismes" does not exist
db_1             | 2021-09-15 11:50:39.369 UTC [92] STATEMENT:  ALTER TABLE ONLY bib_organismes ADD CONSTRAINT pk_bib_organismes PRIMARY KEY (id_organisme);
db_1             | 2021-09-15 11:50:39.369 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.369 UTC [92] STATEMENT:  ALTER TABLE ONLY t_roles ADD CONSTRAINT pk_t_roles PRIMARY KEY (id_role);
db_1             | 2021-09-15 11:50:39.387 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.387 UTC [92] STATEMENT:  CREATE TRIGGER tri_modify_date_insert_t_roles BEFORE INSERT ON t_roles FOR EACH ROW EXECUTE PROCEDURE modify_date_insert();
db_1             | 2021-09-15 11:50:39.387 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.387 UTC [92] STATEMENT:  CREATE TRIGGER tri_modify_date_update_t_roles BEFORE UPDATE ON t_roles FOR EACH ROW EXECUTE PROCEDURE modify_date_update();
db_1             | 2021-09-15 11:50:39.388 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.388 UTC [92] STATEMENT:  ALTER TABLE ONLY t_roles ADD CONSTRAINT t_roles_id_organisme_fkey FOREIGN KEY (id_organisme) REFERENCES bib_organismes(id_organisme) ON UPDATE CASCADE;
db_1             | 2021-09-15 11:50:39.388 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.388 UTC [92] STATEMENT:  ALTER TABLE ONLY cor_roles ADD CONSTRAINT cor_roles_id_role_groupe_fkey FOREIGN KEY (id_role_groupe) REFERENCES t_roles(id_role) ON UPDATE CASCADE ON DELETE CASCADE;
db_1             | 2021-09-15 11:50:39.388 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.388 UTC [92] STATEMENT:  ALTER TABLE ONLY cor_roles ADD CONSTRAINT cor_roles_id_role_utilisateur_fkey FOREIGN KEY (id_role_utilisateur) REFERENCES t_roles(id_role) ON UPDATE CASCADE ON DELETE CASCADE;
db_1             | 2021-09-15 11:50:39.388 UTC [92] ERROR:  relation "bib_organismes" does not exist
db_1             | 2021-09-15 11:50:39.388 UTC [92] STATEMENT:  ALTER TABLE ONLY bib_organismes ADD CONSTRAINT fk_bib_organismes_id_parent FOREIGN KEY (id_parent) REFERENCES bib_organismes(id_organisme) ON UPDATE CASCADE;
db_1             | 2021-09-15 11:50:39.391 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.391 UTC [92] STATEMENT:  ALTER TABLE ONLY cor_role_liste ADD CONSTRAINT fk_cor_role_liste_id_role FOREIGN KEY (id_role) REFERENCES t_roles(id_role) ON UPDATE CASCADE;
db_1             | 2021-09-15 11:50:39.394 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.394 UTC [92] STATEMENT:  ALTER TABLE ONLY cor_role_app_profil ADD CONSTRAINT fk_cor_role_app_profil_id_role FOREIGN KEY (id_role) REFERENCES t_roles(id_role) ON UPDATE CASCADE ON DELETE CASCADE;
db_1             | 2021-09-15 11:50:39.397 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.397 UTC [92] STATEMENT:  ALTER TABLE ONLY cor_role_token ADD CONSTRAINT cor_role_token_fk_id_role FOREIGN KEY (id_role)
db_1             | 	    REFERENCES t_roles (id_role) MATCH SIMPLE
db_1             | 	    ON UPDATE CASCADE ON DELETE CASCADE;
db_1             | 2021-09-15 11:50:39.398 UTC [92] ERROR:  relation "bib_organismes" does not exist
db_1             | 2021-09-15 11:50:39.398 UTC [92] STATEMENT:  ALTER TABLE ONLY temp_users ADD CONSTRAINT temp_user_id_application_fkey FOREIGN KEY (id_organisme)
db_1             | 	    REFERENCES bib_organismes (id_organisme) MATCH SIMPLE
db_1             | 	    ON UPDATE CASCADE ON DELETE CASCADE;
db_1             | 2021-09-15 11:50:39.398 UTC [92] ERROR:  relation "utilisateurs.t_roles" does not exist
db_1             | 2021-09-15 11:50:39.398 UTC [92] STATEMENT:  CREATE INDEX i_utilisateurs_groupe
db_1             | 	  ON utilisateurs.t_roles
db_1             | 	  USING btree
db_1             | 	  (groupe);
db_1             | 2021-09-15 11:50:39.399 UTC [92] ERROR:  relation "utilisateurs.t_roles" does not exist
db_1             | 2021-09-15 11:50:39.399 UTC [92] STATEMENT:  CREATE INDEX i_utilisateurs_nom_prenom
db_1             | 	  ON utilisateurs.t_roles
db_1             | 	  USING btree
db_1             | 	  (nom_role, prenom_role);
db_1             | 2021-09-15 11:50:39.399 UTC [92] ERROR:  relation "utilisateurs.t_roles" does not exist
db_1             | 2021-09-15 11:50:39.399 UTC [92] STATEMENT:  CREATE INDEX i_utilisateurs_active
db_1             | 	  ON utilisateurs.t_roles
db_1             | 	  USING btree
db_1             | 	  (active);
db_1             | 2021-09-15 11:50:39.401 UTC [92] ERROR:  relation "utilisateurs.t_roles" does not exist at character 888
db_1             | 2021-09-15 11:50:39.401 UTC [92] STATEMENT:  CREATE OR REPLACE VIEW v_userslist_forall_menu AS
db_1             | 	 SELECT a.groupe,
db_1             | 	    a.id_role,
db_1             | 	    a.uuid_role,
db_1             | 	    a.identifiant,
db_1             | 	    a.nom_role,
db_1             | 	    a.prenom_role,
db_1             | 	    (upper(a.nom_role::text) || ' '::text) || a.prenom_role::text AS nom_complet,
db_1             | 	    a.desc_role,
db_1             | 	    a.pass,
db_1             | 	    a.pass_plus,
db_1             | 	    a.email,
db_1             | 	    a.id_organisme,
db_1             | 	    a.organisme,
db_1             | 	    a.id_unite,
db_1             | 	    a.remarques,
db_1             | 	    a.date_insert,
db_1             | 	    a.date_update,
db_1             | 	    a.id_menu
db_1             | 	   FROM ( SELECT u.groupe,
db_1             | 	            u.id_role,
db_1             | 	            u.uuid_role,
db_1             | 	            u.identifiant,
db_1             | 	            u.nom_role,
db_1             | 	            u.prenom_role,
db_1             | 	            u.desc_role,
db_1             | 	            u.pass,
db_1             | 	            u.pass_plus,
db_1             | 	            u.email,
db_1             | 	            u.id_organisme,
db_1             | 	            o.nom_organisme AS organisme,
db_1             | 	            0 AS id_unite,
db_1             | 	            u.remarques,
db_1             | 	            u.date_insert,
db_1             | 	            u.date_update,
db_1             | 	            c.id_liste AS id_menu
db_1             | 	           FROM utilisateurs.t_roles u
db_1             | 	             JOIN utilisateurs.cor_role_liste c ON c.id_role = u.id_role
db_1             | 	             LEFT JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme
db_1             | 	          WHERE u.groupe = false AND u.active = true
db_1             | 	        UNION
db_1             | 	         SELECT u.groupe,
db_1             | 	            u.id_role,
db_1             | 	            u.uuid_role,
db_1             | 	            u.identifiant,
db_1             | 	            u.nom_role,
db_1             | 	            u.prenom_role,
db_1             | 	            u.desc_role,
db_1             | 	            u.pass,
db_1             | 	            u.pass_plus,
db_1             | 	            u.email,
db_1             | 	            u.id_organisme,
db_1             | 	            o.nom_organisme AS organisme,
db_1             | 	            0 AS id_unite,
db_1             | 	            u.remarques,
db_1             | 	            u.date_insert,
db_1             | 	            u.date_update,
db_1             | 	            c.id_liste AS id_menu
db_1             | 	           FROM utilisateurs.t_roles u
db_1             | 	             JOIN utilisateurs.cor_roles g ON g.id_role_utilisateur = u.id_role
db_1             | 	             JOIN utilisateurs.cor_role_liste c ON c.id_role = g.id_role_groupe
db_1             | 	             LEFT JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme
db_1             | 	          WHERE u.groupe = false AND u.active = true) a;
db_1             | 2021-09-15 11:50:39.401 UTC [92] ERROR:  relation "utilisateurs.t_roles" does not exist at character 889
db_1             | 2021-09-15 11:50:39.401 UTC [92] STATEMENT:  CREATE OR REPLACE VIEW utilisateurs.v_roleslist_forall_applications AS
db_1             | 	SELECT a.groupe,
db_1             | 	    a.active,
db_1             | 	    a.id_role,
db_1             | 	    a.identifiant,
db_1             | 	    a.nom_role,
db_1             | 	    a.prenom_role,
db_1             | 	    a.desc_role,
db_1             | 	    a.pass,
db_1             | 	    a.pass_plus,
db_1             | 	    a.email,
db_1             | 	    a.id_organisme,
db_1             | 	    a.organisme,
db_1             | 	    a.id_unite,
db_1             | 	    a.remarques,
db_1             | 	    a.date_insert,
db_1             | 	    a.date_update,
db_1             | 	    max(a.id_droit) AS id_droit_max,
db_1             | 	    a.id_application
db_1             | 	   FROM ( SELECT u.groupe,
db_1             | 	            u.id_role,
db_1             | 	            u.identifiant,
db_1             | 	            u.nom_role,
db_1             | 	            u.prenom_role,
db_1             | 	            u.desc_role,
db_1             | 	            u.pass,
db_1             | 	            u.pass_plus,
db_1             | 	            u.email,
db_1             | 	            u.id_organisme,
db_1             | 		    u.active,
db_1             | 	            o.nom_organisme AS organisme,
db_1             | 	            0 AS id_unite,
db_1             | 	            u.remarques,
db_1             | 	            u.date_insert,
db_1             | 	            u.date_update,
db_1             | 	            c.id_profil AS id_droit,
db_1             | 	            c.id_application
db_1             | 	           FROM utilisateurs.t_roles u
db_1             | 	             JOIN utilisateurs.cor_role_app_profil c ON c.id_role = u.id_role
db_1             | 	             JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme
db_1             | 	        UNION
db_1             | 	         SELECT u.groupe,
db_1             | 	            u.id_role,
db_1             | 	            u.identifiant,
db_1             | 	            u.nom_role,
db_1             | 	            u.prenom_role,
db_1             | 	            u.desc_role,
db_1             | 	            u.pass,
db_1             | 	            u.pass_plus,
db_1             | 	            u.email,
db_1             | 	            u.id_organisme,
db_1             | 	            u.active,
db_1             | 	            o.nom_organisme AS organisme,
db_1             | 	            0 AS id_unite,
db_1             | 	            u.remarques,
db_1             | 	            u.date_insert,
db_1             | 	            u.date_update,
db_1             | 	            c.id_profil AS id_droit,
db_1             | 	            c.id_application
db_1             | 	           FROM utilisateurs.t_roles u
db_1             | 	             JOIN utilisateurs.cor_roles g ON g.id_role_utilisateur = u.id_role OR g.id_role_groupe = u.id_role
db_1             | 	             JOIN utilisateurs.cor_role_app_profil c ON c.id_role = g.id_role_groupe
db_1             | 	             LEFT JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme
db_1             | 	          ) a
db_1             | 	  WHERE a.active = true
db_1             | 	  GROUP BY a.groupe, a.active, a.id_role, a.identifiant, a.nom_role, a.prenom_role, a.desc_role, a.pass, a.pass_plus, a.email, a.id_organisme, a.organisme, a.id_unite, a.remarques, a.date_insert, a.date_update, a.id_application;
db_1             | 2021-09-15 11:50:39.401 UTC [92] ERROR:  relation "utilisateurs.v_roleslist_forall_applications" does not exist at character 86
db_1             | 2021-09-15 11:50:39.401 UTC [92] STATEMENT:  CREATE OR REPLACE VIEW utilisateurs.v_userslist_forall_applications AS
db_1             | 	SELECT * FROM utilisateurs.v_roleslist_forall_applications
db_1             | 	WHERE groupe = false;
db_1             | 2021-09-15 11:50:39.496 UTC [94] ERROR:  relation "bib_organismes" does not exist at character 13
db_1             | 2021-09-15 11:50:39.496 UTC [94] STATEMENT:  INSERT INTO bib_organismes (nom_organisme, adresse_organisme, cp_organisme, ville_organisme, tel_organisme, fax_organisme, email_organisme, id_organisme) VALUES 
db_1             | 	('Autre', '', '', '', '', '', '', -1)
db_1             | 	;
db_1             | 2021-09-15 11:50:39.496 UTC [94] ERROR:  relation "bib_organismes" does not exist at character 13
db_1             | 2021-09-15 11:50:39.496 UTC [94] STATEMENT:  INSERT INTO bib_organismes (nom_organisme, adresse_organisme, cp_organisme, ville_organisme, tel_organisme) VALUES 
db_1             | 	('ma structure test', 'Rue des bois', '00000', 'VILLE', '00-00-99-00-99');
db_1             | 2021-09-15 11:50:39.496 UTC [94] ERROR:  relation "t_roles" does not exist at character 13
db_1             | 2021-09-15 11:50:39.496 UTC [94] STATEMENT:  INSERT INTO t_roles (groupe, id_role, identifiant, nom_role, prenom_role, desc_role, pass, email, date_insert, date_update, id_organisme, remarques) VALUES 
db_1             | 	(true, 7, NULL, 'Grp_en_poste', NULL, 'Tous les agents en poste dans la structure', NULL, NULL, NULL, NULL, NULL, 'Groupe des agents de la structure avec droits d''écriture limité')
db_1             | 	,(true, 9, NULL, 'Grp_admin', NULL, 'Tous les administrateurs', NULL, NULL, NULL, NULL, NULL, 'Groupe à droit total')
db_1             | 	;
db_1             | 2021-09-15 11:50:39.496 UTC [94] ERROR:  relation "t_roles" does not exist at character 13
db_1             | 2021-09-15 11:50:39.496 UTC [94] STATEMENT:  INSERT INTO t_roles (groupe, id_role, identifiant, nom_role, prenom_role, desc_role, pass, email, date_insert, date_update, id_organisme, remarques, pass_plus) VALUES 
db_1             | 	(false, 1, 'admin', 'Administrateur', 'test', NULL, '21232f297a57a5a743894a0e4a801fc3', NULL, NULL, NULL, -1, 'utilisateur test à modifier', '$2y$13$TMuRXgvIg6/aAez0lXLLFu0lyPk4m8N55NDhvLoUHh/Ar3rFzjFT.')
db_1             | 	,(false, 2, 'agent', 'Agent', 'test', NULL, 'b33aed8f3134996703dc39f9a7c95783', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL)
db_1             | 	,(false, 3, 'partenaire', 'Partenaire', 'test', NULL, '5bd40a8524882d75f3083903f2c912fc', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL)
db_1             | 	,(false, 4, 'pierre.paul', 'Paul', 'Pierre', NULL, '21232f297a57a5a743894a0e4a801fc3', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL)
db_1             | 	,(false, 5, 'validateur', 'Validateur', 'test', NULL, '21232f297a57a5a743894a0e4a801fc3', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL)
db_1             | 	;
db_1             | 2021-09-15 11:50:39.497 UTC [94] ERROR:  relation "utilisateurs.t_roles" does not exist at character 77
db_1             | 2021-09-15 11:50:39.497 UTC [94] STATEMENT:  SELECT pg_catalog.setval('t_roles_id_role_seq', (SELECT max(id_role)+1 FROM utilisateurs.t_roles), false);

log installation ``` 2021-09-15 11:49:30.942 UTC [35] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" db_1 | 2021-09-15 11:49:30.954 UTC [36] LOG: database system was shut down at 2021-09-15 11:49:30 UTC db_1 | 2021-09-15 11:49:30.957 UTC [35] LOG: database system is ready to accept connections db_1 | done db_1 | server started db_1 | db_1 | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/10_postgis.sh db_1 | CREATE DATABASE db_1 | Loading PostGIS extensions into template_postgis db_1 | CREATE EXTENSION db_1 | CREATE EXTENSION db_1 | CREATE EXTENSION db_1 | CREATE EXTENSION db_1 | Loading PostGIS extensions into postgres db_1 | CREATE EXTENSION db_1 | CREATE EXTENSION db_1 | CREATE EXTENSION db_1 | CREATE EXTENSION db_1 | db_1 | waiting for server to shut down....2021-09-15 11:49:34.042 UTC [35] LOG: received fast shutdown request db_1 | 2021-09-15 11:49:34.043 UTC [35] LOG: aborting any active transactions db_1 | 2021-09-15 11:49:34.043 UTC [35] LOG: background worker "logical replication launcher" (PID 42) exited with exit code 1 db_1 | 2021-09-15 11:49:34.045 UTC [37] LOG: shutting down db_1 | 2021-09-15 11:49:34.115 UTC [35] LOG: database system is shut down db_1 | done db_1 | server stopped db_1 | db_1 | PostgreSQL init process complete; ready for start up. db_1 | db_1 | 2021-09-15 11:49:34.154 UTC [1] LOG: starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit db_1 | 2021-09-15 11:49:34.154 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 db_1 | 2021-09-15 11:49:34.154 UTC [1] LOG: listening on IPv6 address "::", port 5432 db_1 | 2021-09-15 11:49:34.157 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" db_1 | 2021-09-15 11:49:34.178 UTC [54] LOG: database system was shut down at 2021-09-15 11:49:34 UTC db_1 | 2021-09-15 11:49:34.183 UTC [1] LOG: database system is ready to accept connections db_1 | 2021-09-15 11:50:10.593 UTC [84] ERROR: schema "taxonomie" already exists db_1 | 2021-09-15 11:50:10.593 UTC [84] STATEMENT: CREATE SCHEMA taxonomie; db_1 | 2021-09-15 11:50:37.845 UTC [88] ERROR: operator class "gist_trgm_ops" does not exist for access method "gist" db_1 | 2021-09-15 11:50:37.845 UTC [88] STATEMENT: CREATE INDEX i_tri_vm_taxref_list_forautocomplete_search_name db_1 | ON vm_taxref_list_forautocomplete db_1 | USING gist db_1 | (search_name gist_trgm_ops); db_1 | 2021-09-15 11:50:38.019 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.019 UTC [91] DETAIL: Key (cd_nom)=(67111) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.019 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (67111, 67111, 'Ablette'); db_1 | 2021-09-15 11:50:38.019 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.019 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.019 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.020 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.020 UTC [91] DETAIL: Key (cd_nom)=(60612) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.020 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (60612, 60612, 'Lynx boréal'); db_1 | 2021-09-15 11:50:38.020 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.020 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.020 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.021 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.021 UTC [91] DETAIL: Key (cd_nom)=(351) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.021 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (351, 351, 'Grenouille rousse'); db_1 | 2021-09-15 11:50:38.021 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.021 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.021 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.021 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.021 UTC [91] DETAIL: Key (cd_nom)=(8326) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.021 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (8326, 8326, 'Cicindèle hybride'); db_1 | 2021-09-15 11:50:38.021 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.021 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.021 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.022 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.022 UTC [91] DETAIL: Key (cd_nom)=(11165) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.022 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (11165, 11165, 'Coccinelle à 7 points'); db_1 | 2021-09-15 11:50:38.022 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.022 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.022 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.022 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.022 UTC [91] DETAIL: Key (cd_nom)=(18437) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.022 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (18437, 18437, 'Ecrevisse à pieds blancs'); db_1 | 2021-09-15 11:50:38.023 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.023 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.023 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.023 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.023 UTC [91] DETAIL: Key (cd_nom)=(81065) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.023 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (81065, 81065, 'Alchémille rampante'); db_1 | 2021-09-15 11:50:38.023 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.023 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.023 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.023 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.023 UTC [91] DETAIL: Key (cd_nom)=(95186) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.023 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (95186, 95186, 'Inule fétide'); db_1 | 2021-09-15 11:50:38.024 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.024 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.024 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.024 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.024 UTC [91] DETAIL: Key (cd_nom)=(713776) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.024 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais, comments) VALUES (713776, 209902, '-', 'un synonyme'); db_1 | 2021-09-15 11:50:39.345 UTC [92] ERROR: function public.uuid_generate_v4() does not exist at character 146 db_1 | 2021-09-15 11:50:39.345 UTC [92] HINT: No function matches the given name and argument types. You might need to add explicit type casts. db_1 | 2021-09-15 11:50:39.345 UTC [92] STATEMENT: CREATE TABLE IF NOT EXISTS t_roles ( db_1 | groupe boolean DEFAULT false NOT NULL, db_1 | id_role serial NOT NULL, db_1 | uuid_role uuid NOT NULL DEFAULT public.uuid_generate_v4(), db_1 | identifiant character varying(100), db_1 | nom_role character varying(50), db_1 | prenom_role character varying(50), db_1 | desc_role text, db_1 | pass character varying(100), db_1 | pass_plus text, db_1 | email character varying(250), db_1 | id_organisme integer, db_1 | remarques text, db_1 | active boolean DEFAULT true, db_1 | champs_addi jsonb, db_1 | date_insert timestamp without time zone, db_1 | date_update timestamp without time zone db_1 | ); db_1 | 2021-09-15 11:50:39.346 UTC [92] ERROR: function public.uuid_generate_v4() does not exist at character 120 db_1 | 2021-09-15 11:50:39.346 UTC [92] HINT: No function matches the given name and argument types. You might need to add explicit type casts. db_1 | 2021-09-15 11:50:39.346 UTC [92] STATEMENT: CREATE TABLE IF NOT EXISTS bib_organismes ( nginx_1 | /docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh db_1 | id_organisme serial NOT NULL, db_1 | uuid_organisme uuid NOT NULL DEFAULT public.uuid_generate_v4(), db_1 | nom_organisme character varying(100) NOT NULL, db_1 | adresse_organisme character varying(128), db_1 | cp_organisme character varying(5), db_1 | ville_organisme character varying(100), db_1 | tel_organisme character varying(14), db_1 | fax_organisme character varying(14), db_1 | email_organisme character varying(100), db_1 | url_organisme character varying(255), db_1 | url_logo character varying(255), db_1 | id_parent integer db_1 | ); db_1 | 2021-09-15 11:50:39.369 UTC [92] ERROR: relation "bib_organismes" does not exist db_1 | 2021-09-15 11:50:39.369 UTC [92] STATEMENT: ALTER TABLE ONLY bib_organismes ADD CONSTRAINT pk_bib_organismes PRIMARY KEY (id_organisme); db_1 | 2021-09-15 11:50:39.369 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.369 UTC [92] STATEMENT: ALTER TABLE ONLY t_roles ADD CONSTRAINT pk_t_roles PRIMARY KEY (id_role); db_1 | 2021-09-15 11:50:39.387 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.387 UTC [92] STATEMENT: CREATE TRIGGER tri_modify_date_insert_t_roles BEFORE INSERT ON t_roles FOR EACH ROW EXECUTE PROCEDURE modify_date_insert(); db_1 | 2021-09-15 11:50:39.387 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.387 UTC [92] STATEMENT: CREATE TRIGGER tri_modify_date_update_t_roles BEFORE UPDATE ON t_roles FOR EACH ROW EXECUTE PROCEDURE modify_date_update(); db_1 | 2021-09-15 11:50:39.388 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.388 UTC [92] STATEMENT: ALTER TABLE ONLY t_roles ADD CONSTRAINT t_roles_id_organisme_fkey FOREIGN KEY (id_organisme) REFERENCES bib_organismes(id_organisme) ON UPDATE CASCADE; db_1 | 2021-09-15 11:50:39.388 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.388 UTC [92] STATEMENT: ALTER TABLE ONLY cor_roles ADD CONSTRAINT cor_roles_id_role_groupe_fkey FOREIGN KEY (id_role_groupe) REFERENCES t_roles(id_role) ON UPDATE CASCADE ON DELETE CASCADE; db_1 | 2021-09-15 11:50:39.388 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.388 UTC [92] STATEMENT: ALTER TABLE ONLY cor_roles ADD CONSTRAINT cor_roles_id_role_utilisateur_fkey FOREIGN KEY (id_role_utilisateur) REFERENCES t_roles(id_role) ON UPDATE CASCADE ON DELETE CASCADE; db_1 | 2021-09-15 11:50:39.388 UTC [92] ERROR: relation "bib_organismes" does not exist db_1 | 2021-09-15 11:50:39.388 UTC [92] STATEMENT: ALTER TABLE ONLY bib_organismes ADD CONSTRAINT fk_bib_organismes_id_parent FOREIGN KEY (id_parent) REFERENCES bib_organismes(id_organisme) ON UPDATE CASCADE; db_1 | 2021-09-15 11:50:39.391 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.391 UTC [92] STATEMENT: ALTER TABLE ONLY cor_role_liste ADD CONSTRAINT fk_cor_role_liste_id_role FOREIGN KEY (id_role) REFERENCES t_roles(id_role) ON UPDATE CASCADE; db_1 | 2021-09-15 11:50:39.394 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.394 UTC [92] STATEMENT: ALTER TABLE ONLY cor_role_app_profil ADD CONSTRAINT fk_cor_role_app_profil_id_role FOREIGN KEY (id_role) REFERENCES t_roles(id_role) ON UPDATE CASCADE ON DELETE CASCADE; db_1 | 2021-09-15 11:50:39.397 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.397 UTC [92] STATEMENT: ALTER TABLE ONLY cor_role_token ADD CONSTRAINT cor_role_token_fk_id_role FOREIGN KEY (id_role) db_1 | REFERENCES t_roles (id_role) MATCH SIMPLE db_1 | ON UPDATE CASCADE ON DELETE CASCADE; db_1 | 2021-09-15 11:50:39.398 UTC [92] ERROR: relation "bib_organismes" does not exist db_1 | 2021-09-15 11:50:39.398 UTC [92] STATEMENT: ALTER TABLE ONLY temp_users ADD CONSTRAINT temp_user_id_application_fkey FOREIGN KEY (id_organisme) db_1 | REFERENCES bib_organismes (id_organisme) MATCH SIMPLE db_1 | ON UPDATE CASCADE ON DELETE CASCADE; db_1 | 2021-09-15 11:50:39.398 UTC [92] ERROR: relation "utilisateurs.t_roles" does not exist db_1 | 2021-09-15 11:50:39.398 UTC [92] STATEMENT: CREATE INDEX i_utilisateurs_groupe db_1 | ON utilisateurs.t_roles db_1 | USING btree db_1 | (groupe); db_1 | 2021-09-15 11:50:39.399 UTC [92] ERROR: relation "utilisateurs.t_roles" does not exist db_1 | 2021-09-15 11:50:39.399 UTC [92] STATEMENT: CREATE INDEX i_utilisateurs_nom_prenom db_1 | ON utilisateurs.t_roles db_1 | USING btree db_1 | (nom_role, prenom_role); db_1 | 2021-09-15 11:50:39.399 UTC [92] ERROR: relation "utilisateurs.t_roles" does not exist db_1 | 2021-09-15 11:50:39.399 UTC [92] STATEMENT: CREATE INDEX i_utilisateurs_active db_1 | ON utilisateurs.t_roles db_1 | USING btree db_1 | (active); db_1 | 2021-09-15 11:50:39.401 UTC [92] ERROR: relation "utilisateurs.t_roles" does not exist at character 888 db_1 | 2021-09-15 11:50:39.401 UTC [92] STATEMENT: CREATE OR REPLACE VIEW v_userslist_forall_menu AS db_1 | SELECT a.groupe, db_1 | a.id_role, db_1 | a.uuid_role, db_1 | a.identifiant, db_1 | a.nom_role, db_1 | a.prenom_role, db_1 | (upper(a.nom_role::text) || ' '::text) || a.prenom_role::text AS nom_complet, db_1 | a.desc_role, db_1 | a.pass, db_1 | a.pass_plus, db_1 | a.email, db_1 | a.id_organisme, db_1 | a.organisme, db_1 | a.id_unite, db_1 | a.remarques, db_1 | a.date_insert, db_1 | a.date_update, db_1 | a.id_menu db_1 | FROM ( SELECT u.groupe, db_1 | u.id_role, db_1 | u.uuid_role, db_1 | u.identifiant, db_1 | u.nom_role, db_1 | u.prenom_role, db_1 | u.desc_role, db_1 | u.pass, db_1 | u.pass_plus, db_1 | u.email, db_1 | u.id_organisme, db_1 | o.nom_organisme AS organisme, db_1 | 0 AS id_unite, db_1 | u.remarques, db_1 | u.date_insert, db_1 | u.date_update, db_1 | c.id_liste AS id_menu db_1 | FROM utilisateurs.t_roles u db_1 | JOIN utilisateurs.cor_role_liste c ON c.id_role = u.id_role db_1 | LEFT JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme db_1 | WHERE u.groupe = false AND u.active = true db_1 | UNION db_1 | SELECT u.groupe, db_1 | u.id_role, db_1 | u.uuid_role, db_1 | u.identifiant, db_1 | u.nom_role, db_1 | u.prenom_role, db_1 | u.desc_role, db_1 | u.pass, db_1 | u.pass_plus, db_1 | u.email, db_1 | u.id_organisme, db_1 | o.nom_organisme AS organisme, db_1 | 0 AS id_unite, db_1 | u.remarques, db_1 | u.date_insert, db_1 | u.date_update, db_1 | c.id_liste AS id_menu db_1 | FROM utilisateurs.t_roles u db_1 | JOIN utilisateurs.cor_roles g ON g.id_role_utilisateur = u.id_role db_1 | JOIN utilisateurs.cor_role_liste c ON c.id_role = g.id_role_groupe db_1 | LEFT JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme db_1 | WHERE u.groupe = false AND u.active = true) a; db_1 | 2021-09-15 11:50:39.401 UTC [92] ERROR: relation "utilisateurs.t_roles" does not exist at character 889 db_1 | 2021-09-15 11:50:39.401 UTC [92] STATEMENT: CREATE OR REPLACE VIEW utilisateurs.v_roleslist_forall_applications AS db_1 | SELECT a.groupe, db_1 | a.active, db_1 | a.id_role, db_1 | a.identifiant, db_1 | a.nom_role, db_1 | a.prenom_role, db_1 | a.desc_role, db_1 | a.pass, db_1 | a.pass_plus, db_1 | a.email, db_1 | a.id_organisme, db_1 | a.organisme, db_1 | a.id_unite, db_1 | a.remarques, db_1 | a.date_insert, db_1 | a.date_update, db_1 | max(a.id_droit) AS id_droit_max, db_1 | a.id_application db_1 | FROM ( SELECT u.groupe, db_1 | u.id_role, db_1 | u.identifiant, db_1 | u.nom_role, db_1 | u.prenom_role, db_1 | u.desc_role, db_1 | u.pass, db_1 | u.pass_plus, db_1 | u.email, db_1 | u.id_organisme, db_1 | u.active, db_1 | o.nom_organisme AS organisme, db_1 | 0 AS id_unite, db_1 | u.remarques, db_1 | u.date_insert, db_1 | u.date_update, db_1 | c.id_profil AS id_droit, db_1 | c.id_application db_1 | FROM utilisateurs.t_roles u db_1 | JOIN utilisateurs.cor_role_app_profil c ON c.id_role = u.id_role db_1 | JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme db_1 | UNION db_1 | SELECT u.groupe, db_1 | u.id_role, db_1 | u.identifiant, db_1 | u.nom_role, db_1 | u.prenom_role, db_1 | u.desc_role, db_1 | u.pass, db_1 | u.pass_plus, db_1 | u.email, db_1 | u.id_organisme, db_1 | u.active, db_1 | o.nom_organisme AS organisme, db_1 | 0 AS id_unite, db_1 | u.remarques, db_1 | u.date_insert, db_1 | u.date_update, db_1 | c.id_profil AS id_droit, db_1 | c.id_application db_1 | FROM utilisateurs.t_roles u db_1 | JOIN utilisateurs.cor_roles g ON g.id_role_utilisateur = u.id_role OR g.id_role_groupe = u.id_role db_1 | JOIN utilisateurs.cor_role_app_profil c ON c.id_role = g.id_role_groupe db_1 | LEFT JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme db_1 | ) a db_1 | WHERE a.active = true db_1 | GROUP BY a.groupe, a.active, a.id_role, a.identifiant, a.nom_role, a.prenom_role, a.desc_role, a.pass, a.pass_plus, a.email, a.id_organisme, a.organisme, a.id_unite, a.remarques, a.date_insert, a.date_update, a.id_application; db_1 | 2021-09-15 11:50:39.401 UTC [92] ERROR: relation "utilisateurs.v_roleslist_forall_applications" does not exist at character 86 db_1 | 2021-09-15 11:50:39.401 UTC [92] STATEMENT: CREATE OR REPLACE VIEW utilisateurs.v_userslist_forall_applications AS db_1 | SELECT * FROM utilisateurs.v_roleslist_forall_applications db_1 | WHERE groupe = false; db_1 | 2021-09-15 11:50:39.496 UTC [94] ERROR: relation "bib_organismes" does not exist at character 13 db_1 | 2021-09-15 11:50:39.496 UTC [94] STATEMENT: INSERT INTO bib_organismes (nom_organisme, adresse_organisme, cp_organisme, ville_organisme, tel_organisme, fax_organisme, email_organisme, id_organisme) VALUES db_1 | ('Autre', '', '', '', '', '', '', -1) db_1 | ; db_1 | 2021-09-15 11:50:39.496 UTC [94] ERROR: relation "bib_organismes" does not exist at character 13 db_1 | 2021-09-15 11:50:39.496 UTC [94] STATEMENT: INSERT INTO bib_organismes (nom_organisme, adresse_organisme, cp_organisme, ville_organisme, tel_organisme) VALUES db_1 | ('ma structure test', 'Rue des bois', '00000', 'VILLE', '00-00-99-00-99'); db_1 | 2021-09-15 11:50:39.496 UTC [94] ERROR: relation "t_roles" does not exist at character 13 db_1 | 2021-09-15 11:50:39.496 UTC [94] STATEMENT: INSERT INTO t_roles (groupe, id_role, identifiant, nom_role, prenom_role, desc_role, pass, email, date_insert, date_update, id_organisme, remarques) VALUES db_1 | (true, 7, NULL, 'Grp_en_poste', NULL, 'Tous les agents en poste dans la structure', NULL, NULL, NULL, NULL, NULL, 'Groupe des agents de la structure avec droits d''écriture limité') db_1 | ,(true, 9, NULL, 'Grp_admin', NULL, 'Tous les administrateurs', NULL, NULL, NULL, NULL, NULL, 'Groupe à droit total') db_1 | ; db_1 | 2021-09-15 11:50:39.496 UTC [94] ERROR: relation "t_roles" does not exist at character 13 db_1 | 2021-09-15 11:50:39.496 UTC [94] STATEMENT: INSERT INTO t_roles (groupe, id_role, identifiant, nom_role, prenom_role, desc_role, pass, email, date_insert, date_update, id_organisme, remarques, pass_plus) VALUES db_1 | (false, 1, 'admin', 'Administrateur', 'test', NULL, '21232f297a57a5a743894a0e4a801fc3', NULL, NULL, NULL, -1, 'utilisateur test à modifier', '$2y$13$TMuRXgvIg6/aAez0lXLLFu0lyPk4m8N55NDhvLoUHh/Ar3rFzjFT.') db_1 | ,(false, 2, 'agent', 'Agent', 'test', NULL, 'b33aed8f3134996703dc39f9a7c95783', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL) db_1 | ,(false, 3, 'partenaire', 'Partenaire', 'test', NULL, '5bd40a8524882d75f3083903f2c912fc', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL) db_1 | ,(false, 4, 'pierre.paul', 'Paul', 'Pierre', NULL, '21232f297a57a5a743894a0e4a801fc3', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL) db_1 | ,(false, 5, 'validateur', 'Validateur', 'test', NULL, '21232f297a57a5a743894a0e4a801fc3', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL) db_1 | ; db_1 | 2021-09-15 11:50:39.497 UTC [94] ERROR: relation "utilisateurs.t_roles" does not exist at character 77 db_1 | 2021-09-15 11:50:39.497 UTC [94] STATEMENT: SELECT pg_catalog.setval('t_roles_id_role_seq', (SELECT max(id_role)+1 FROM utilisateurs.t_roles), false); ```

cfr db.session.execute("CREATE SCHEMA IF NOT EXISTS gnc_obstax")

qui doit être exécuté avec python server.py.

Attention que ce fichier a changé avec une dernière version de Gn !

docker-compose exec db bash
psql -h localhost -U postgres -d referentielsdb
\dn

Les schémas existent bien, mais sont vide de tables.