search

wapaAdmin / tww2ag6496

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

Upsert in trigger functions not working #3

Closed wapaAdmin closed 3 months ago

wapaAdmin commented 9 months ago

The trigger functions try to upsert into tww_od (ordinary data) via views. However, Upserting does not work on views because views have no unique constraints.

cymed commented 3 months ago

After discussion with @el-wiss, we drop the trigger function and add the mapping in the python scripts instead