Mercurial > hg > orthanc-databases

diff PostgreSQL/Plugins/PrepareIndex.sql @ 418:a7f0f27fe33c pg-transactions

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
wip: advisory lock around CreateInstance: not ok see WO-139
author Alain Mazy <am@osimis.io>
date Tue, 27 Jun 2023 15:17:39 +0200
parents 7cea966b6829
children 7c1fe5d6c12c
line wrap: on
line diff
--- a/PostgreSQL/Plugins/PrepareIndex.sql	Fri Jun 23 14:26:58 2023 +0200
+++ b/PostgreSQL/Plugins/PrepareIndex.sql	Tue Jun 27 15:17:39 2023 +0200
@@ -8,6 +8,7 @@
        resourceType INTEGER NOT NULL,
        publicId VARCHAR(64) NOT NULL,
        parentId BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE
+       -- UNIQUE (publicId)  -- this is made unique in C++ code (new in plugin v X.Y.Z)
        );
 
 CREATE TABLE MainDicomTags(