Mercurial > hg > orthanc-databases
diff PostgreSQL/Plugins/PrepareIndex.sql @ 431:7c1fe5d6c12c pg-transactions
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