Mercurial > hg > orthanc-databases

diff PostgreSQL/Plugins/PrepareIndex.sql @ 431:7c1fe5d6c12c pg-transactions

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
PG: IncrementGlobalProperty
author Alain Mazy <am@osimis.io>
date Thu, 07 Dec 2023 12:13:43 +0100
parents a7f0f27fe33c
children 8b7c1c423367
line wrap: on
line diff
--- a/PostgreSQL/Plugins/PrepareIndex.sql	Thu Nov 30 14:50:09 2023 +0100
+++ b/PostgreSQL/Plugins/PrepareIndex.sql	Thu Dec 07 12:13:43 2023 +0100
@@ -134,7 +134,8 @@
   
   -- http://stackoverflow.com/a/11299968/881731
   IF EXISTS (SELECT 1 FROM Resources WHERE parentId = old.parentId) THEN
-    -- Signal that the deleted resource has a remaining parent
+    -- Signal that the deleted resource has a 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;
   ELSE