# HG changeset patch
# User Alain Mazy <am@orthanc.team>
# Date 1751269776 -7200
# Node ID 2bf70b3ef0d54e6aba393da61ea19d0a958663c1
# Parent  435ad957f829be5dba5b73c0645b86303077f5af
use SKIP LOCKED in UpdateInvlidChildCounts

diff -r 435ad957f829 -r 2bf70b3ef0d5 PostgreSQL/Plugins/SQL/PrepareIndex.sql
--- a/PostgreSQL/Plugins/SQL/PrepareIndex.sql	Fri Jun 27 15:29:59 2025 +0200
+++ b/PostgreSQL/Plugins/SQL/PrepareIndex.sql	Mon Jun 30 09:49:36 2025 +0200
@@ -715,7 +715,7 @@
     SELECT ARRAY(SELECT internalId
                  FROM Resources
                  WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts)
-                 FOR UPDATE)
+                 FOR UPDATE SKIP LOCKED)
     INTO locked_resources_ids;
 
     -- New rows can be added in the meantime, they won't be taken into account this time.