--- a/PostgreSQL/Plugins/ResourceDeletedFunc.sql	Wed Dec 13 15:48:56 2023 +0100
+++ b/PostgreSQL/Plugins/ResourceDeletedFunc.sql	Wed Dec 13 16:52:06 2023 +0100
@@ -9,12 +9,6 @@
   --RAISE NOTICE 'Delete resource %', old.parentId;
   INSERT INTO DeletedResources VALUES (old.resourceType, old.publicId);
   
-  -- If this resource still has siblings, keep track of the remaining parent
-  -- (a parent that must not be deleted but whose LastUpdate must be updated)
-  INSERT INTO RemainingAncestor SELECT resourceType, publicId
-                                FROM Resources 
-                                WHERE internalId = old.parentId
-                                      AND EXISTS (SELECT 1 FROM Resources WHERE parentId = old.parentId);
   -- If this resource is the latest child, delete the parent
   DELETE FROM Resources WHERE internalId = old.parentId
                               AND NOT EXISTS (SELECT 1 FROM Resources WHERE parentId = old.parentId);
@@ -31,3 +25,28 @@
 DROP TABLE IF EXISTS DeletedFiles;
 DROP TABLE IF EXISTS RemainingAncestor;
 DROP TABLE IF EXISTS DeletedResources;
+
+
+CREATE OR REPLACE FUNCTION DeleteResource(
+    IN id BIGINT,
+    OUT remainingAncestorResourceType INTEGER,
+    OUT remainingAncestorPublicId TEXT) AS $body$
+
+DECLARE
+    deleted_row RECORD;
+
+BEGIN
+
+    DELETE FROM Resources WHERE internalId=id RETURNING * INTO deleted_row;
+    -- note: there is a ResourceDeletedFunc trigger that will execute here and delete the parents if there are no remaining children + 
+
+    -- If this resource still has siblings, keep track of the remaining parent
+    -- (a parent that must not be deleted but whose LastUpdate must be updated)
+    SELECT resourceType, publicId INTO remainingAncestorResourceType, remainingAncestorPublicId
+        FROM Resources 
+        WHERE internalId = deleted_row.parentId
+            AND EXISTS (SELECT 1 FROM Resources WHERE parentId = deleted_row.parentId);
+
+END;
+
+$body$ LANGUAGE plpgsql;