# HG changeset patch
# User Alain Mazy <am@osimis.io>
# Date 1705516283 -3600
# Node ID 392ac133a49136b7c25800bcfc6dddc500ac49dd
# Parent  c437ec7be2b0f91eb7e07accd12baeb0710a61ad
fix downgrade proc

diff -r c437ec7be2b0 -r 392ac133a491 PostgreSQL/Plugins/SQL/Downgrades/V6.2ToV6.1.sql
--- a/PostgreSQL/Plugins/SQL/Downgrades/V6.2ToV6.1.sql	Wed Jan 17 17:30:08 2024 +0100
+++ b/PostgreSQL/Plugins/SQL/Downgrades/V6.2ToV6.1.sql	Wed Jan 17 19:31:23 2024 +0100
@@ -130,7 +130,13 @@
        );
 
 
--- this trigger has been removed in 6.2
+-- these triggers have been introduced in 6.2, remove them
+DROP TRIGGER IF EXISTS IncrementResourcesTracker on Resources;
+DROP TRIGGER IF EXISTS DecrementResourcesTracker on Resources;
+DROP FUNCTION IF EXISTS IncrementResourcesTrackerFunc;
+DROP FUNCTION IF EXISTS DecrementResourcesTrackerFunc;
+
+-- this trigger has been removed in 6.2, reinstall it
 CREATE OR REPLACE FUNCTION CountResourcesTrackerFunc()
 RETURNS TRIGGER AS $$
 BEGIN