# HG changeset patch # User Alain Mazy # Date 1705508983 -3600 # Node ID da0586c5cbd8172b0c7d13ba1db8094a40f09414 # Parent f2427f94d8793699428c5e86a65959bd1e24bb0e fix diff -r f2427f94d879 -r da0586c5cbd8 PostgreSQL/Plugins/SQL/PrepareIndex.sql --- a/PostgreSQL/Plugins/SQL/PrepareIndex.sql Wed Jan 17 16:22:08 2024 +0100 +++ b/PostgreSQL/Plugins/SQL/PrepareIndex.sql Wed Jan 17 17:29:43 2024 +0100 @@ -298,6 +298,7 @@ END; $body$ LANGUAGE plpgsql; +DROP TRIGGER IF EXISTS AttachedFileDeleted on AttachedFiles; CREATE TRIGGER AttachedFileDeleted AFTER DELETE ON AttachedFiles FOR EACH ROW