[Pkg-nagios-devel] Bug#861077: icinga-idoutils: fails to upgrade squeeze -> wheezy -> jessie -> stretch

[Bas Couwenberg]

Source: icinga
Followup-For: Bug #861077
Control: tags -1 patch

Dear Maintainer,

It's probably sufficient to fix the case of the constraints as per the
attached patch. I've haven't tested this (yet), as I don't know who to
reproduce the issue with piuparts.

Andreas, how can the upgrade test you performed be reproduced by others
using piuparts?

Kind Regards,

Bas
-------------- next part --------------
diff --git a/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.13.0.sql b/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.13.0.sql
index d0c9a92..ab5608a 100644
--- a/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.13.0.sql
+++ b/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.13.0.sql
@@ -11,8 +11,8 @@
 -- #7765 drop unique constraint
 -- -----------------------------------------
 
-ALTER TABLE icinga_servicedependencies DROP CONSTRAINT uq_servicedependencies;
-ALTER TABLE icinga_hostdependencies DROP CONSTRAINT uq_hostdependencies;
+ALTER TABLE icinga_servicedependencies DROP CONSTRAINT UQ_servicedependencies;
+ALTER TABLE icinga_hostdependencies DROP CONSTRAINT UQ_hostdependencies;
 
 CREATE INDEX idx_servicedependencies ON icinga_servicedependencies(instance_id,config_type,service_object_id,dependent_service_object_id,dependency_type,inherits_parent,fail_on_ok,fail_on_warning,fail_on_unknown,fail_on_critical);
 CREATE INDEX idx_hostdependencies ON icinga_hostdependencies(instance_id,config_type,host_object_id,dependent_host_object_id,dependency_type,inherits_parent,fail_on_up,fail_on_down,fail_on_unreachable);