Mercurial > hg > orthanc-databases

comparison PostgreSQL/Plugins/SQL/Downgrades/V6.2ToV6.1.sql @ 451:392ac133a491 pg-transactions

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fix downgrade proc
author Alain Mazy <am@osimis.io>
date Wed, 17 Jan 2024 19:31:23 +0100
parents f2427f94d879
children
comparison
equal deleted inserted replaced
450:c437ec7be2b0 451:392ac133a491
128 resourceType INTEGER NOT NULL, 128 resourceType INTEGER NOT NULL,
129 publicId VARCHAR(64) NOT NULL 129 publicId VARCHAR(64) NOT NULL
130 ); 130 );
131 131
132 132
133 -- this trigger has been removed in 6.2 133 -- these triggers have been introduced in 6.2, remove them
134 DROP TRIGGER IF EXISTS IncrementResourcesTracker on Resources;
135 DROP TRIGGER IF EXISTS DecrementResourcesTracker on Resources;
136 DROP FUNCTION IF EXISTS IncrementResourcesTrackerFunc;
137 DROP FUNCTION IF EXISTS DecrementResourcesTrackerFunc;
138
139 -- this trigger has been removed in 6.2, reinstall it
134 CREATE OR REPLACE FUNCTION CountResourcesTrackerFunc() 140 CREATE OR REPLACE FUNCTION CountResourcesTrackerFunc()
135 RETURNS TRIGGER AS $$ 141 RETURNS TRIGGER AS $$
136 BEGIN 142 BEGIN
137 IF TG_OP = 'INSERT' THEN 143 IF TG_OP = 'INSERT' THEN
138 UPDATE GlobalIntegers SET value = value + 1 WHERE key = new.resourceType + 2; 144 UPDATE GlobalIntegers SET value = value + 1 WHERE key = new.resourceType + 2;