search

teksi / wastewater

[DEV] Future TEKSI wastewater module, adapted data model to fit VSA-DSS 2020 new standard
https://teksi.github.io/wastewater
GNU General Public License v3.0
1 stars 5 forks source link

Command line setup not functionnal #163

Open ponceta opened 7 months ago

ponceta commented 7 months ago

We miss some statements to run the database/script/setup.sh

CREATE TABLE
psql:/home/pulpoar/git/wastewater/datamodel/scripts/../changelogs/0001/03_tww_db_dss.sql:33: ERREUR:  la fonction uuid_generate_v4() n'existe pas
LIGNE 3 :    id uuid NOT NULL DEFAULT uuid_generate_v4(),
cymed commented 6 months ago

We miss some statements to run the database/script/setup.sh

* [ ]  customization of SRID

The SRID of the interlis is predefined to be 2056 (limitation of coordinate range)

* [ ]  customization of PGSERVICE

there is a --pgservice flag

* [ ]  statement to add extension UUID is missing

Do we need this here? I think it is smarter to catch the error and parse it so the dbadmin can install it. Otherwise we need sysadmin rights for exports

CREATE TABLE
psql:/home/pulpoar/git/wastewater/datamodel/scripts/../changelogs/0001/03_tww_db_dss.sql:33: ERREUR:  la fonction uuid_generate_v4() n'existe pas
LIGNE 3 :    id uuid NOT NULL DEFAULT uuid_generate_v4(),

Do you have the Postgres extension "uuid-ossp" installed?