Mercurial > hg > orthanc-databases

comparison PostgreSQL/Plugins/SQL/Upgrades/Rev2ToRev3.sql @ 570:73e784792a51 attach-custom-data

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added missing files
author Alain Mazy <am@orthanc.team>
date Wed, 25 Sep 2024 09:25:58 +0200
parents
children
comparison
equal deleted inserted replaced
569:f18e46d7dbf8 570:73e784792a51
1 -- This file contains part of the changes required to upgrade from Revision 2 to Revision 3 (DB version 6)
2 -- It actually contains only the changes that:
3 -- can not be executed with an idempotent statement in SQL
4 -- or would polute the PrepareIndex.sql
5 -- This file is executed only if the current schema is in revision 2 and it is executed
6 -- before PrepareIndex.sql that is idempotent.
7
8
9
10 DO $body$
11 BEGIN
12
13 BEGIN
14 ALTER TABLE AttachedFiles ADD COLUMN customData TEXT;
15 EXCEPTION
16 WHEN duplicate_column THEN RAISE NOTICE 'column customData already exists in AttachedFiles.';
17 END;
18
19 END $body$ LANGUAGE plpgsql;