search

qwat / qwat-data-model

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

Errors on delta 1.2.6 #192

Closed ponceta closed 7 years ago

ponceta commented 7 years ago

I detected many errors on delta files when updating datamodel.

https://github.com/qwat/qwat-data-model/blob/master/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql

psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_row » de la relation « qwat_od.distributor » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_stm » de la relation « qwat_od.distributor » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_row AFTER INSERT OR UPDATE OR DELETE ON qwat_od.distributor FOR EACH ROW EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_stm AFTER TRUNCATE ON qwat_od.distributor FOR EACH STATEMENT EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_row » de la relation « qwat_od.district » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_stm » de la relation « qwat_od.district » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_row AFTER INSERT OR UPDATE OR DELETE ON qwat_od.district FOR EACH ROW EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_stm AFTER TRUNCATE ON qwat_od.district FOR EACH STATEMENT EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_row » de la relation « qwat_od.folder » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_stm » de la relation « qwat_od.folder » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_row AFTER INSERT OR UPDATE OR DELETE ON qwat_od.folder FOR EACH ROW EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_stm AFTER TRUNCATE ON qwat_od.folder FOR EACH STATEMENT EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_row » de la relation « qwat_od.leak » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_stm » de la relation « qwat_od.leak » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_row AFTER INSERT OR UPDATE OR DELETE ON qwat_od.leak FOR EACH ROW EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_stm AFTER TRUNCATE ON qwat_od.leak FOR EACH STATEMENT EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_row » de la relation « qwat_od.pipe » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_stm » de la relation « qwat_od.pipe » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_row AFTER INSERT OR UPDATE OR DELETE ON qwat_od.pipe FOR EACH ROW EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_stm AFTER TRUNCATE ON qwat_od.pipe FOR EACH STATEMENT EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_row » de la relation « qwat_od.protectionzone » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_stm » de la relation « qwat_od.protectionzone » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_row AFTER INSERT OR UPDATE OR DELETE ON qwat_od.protectionzone FOR EACH ROW EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_stm AFTER TRUNCATE ON qwat_od.protectionzone FOR EACH STATEMENT EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_row » de la relation « qwat_od.remote » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_stm » de la relation « qwat_od.remote » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_row AFTER INSERT OR UPDATE OR DELETE ON qwat_od.remote FOR EACH ROW EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_stm AFTER TRUNCATE ON qwat_od.remote FOR EACH STATEMENT EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_row » de la relation « qwat_od.surveypoint » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_stm » de la relation « qwat_od.surveypoint » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_row AFTER INSERT OR UPDATE OR DELETE ON qwat_od.surveypoint FOR EACH ROW EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_stm AFTER TRUNCATE ON qwat_od.surveypoint FOR EACH STATEMENT EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_row » de la relation « qwat_od.printmap » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  le trigger « audit_trigger_stm » de la relation « qwat_od.printmap » n'existe pas, poursuite du traitement
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_row AFTER INSERT OR UPDATE OR DELETE ON qwat_od.printmap FOR EACH ROW EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
psql:/home/pulmexa/qwat-data-model-original/update/delta/delta_1.2.6_fix_audited_tables_and_views.sql:17: NOTICE:  CREATE TRIGGER audit_trigger_stm AFTER TRUNCATE ON qwat_od.printmap FOR EACH STATEMENT EXECUTE PROCEDURE qwat_sys.if_modified_func('true');
haubourg commented 7 years ago

Those are unharmful soft warnings when a "drop if exists" statement does not find the target trigger: see here https://github.com/qwat/qwat-data-model/blob/master/system/audit.sql#L199