search

qwat / qwat-data-model

TEKSI Water module (project QWAT) - PostgreSQL / postgis Datamodel
https://www.teksi.ch
23 stars 25 forks source link

`delta_1.4.0_003_create_fk_leak_type` fails with `column "fk_leak_type" does not exist` #353

Closed olivierdalang closed 1 year ago

olivierdalang commented 2 years ago

Indeed, just realized also that master does not work here (delta_1.4.0_003_create_fk_leak_type fails with column "fk_leak_type" referenced in foreign key constraint does not exist).

This would have been catched by CI easily, but it seems tests don't run (see https://github.com/qwat/qwat-data-model/issues/348)

olivierdalang commented 2 years ago

Had more issues when testing old demo dumps, for example delta_1.3.2_001_missing_spatial_indexes.sql failing because the indexes already exist. Not sure if something is wrong with these old demo dumps, or what exactly is happening.