Mercurial > hg > orthanc-databases
view PostgreSQL/Plugins/SQL/Upgrades/Rev2ToRev3.sql @ 577:991b9b285e1a attach-custom-data tip
fix custom-data handling
author | Alain Mazy <am@orthanc.team> |
---|---|
date | Wed, 02 Oct 2024 09:40:20 +0200 |
parents | 73e784792a51 |
children |
line wrap: on
line source
-- This file contains part of the changes required to upgrade from Revision 2 to Revision 3 (DB version 6) -- It actually contains only the changes that: -- can not be executed with an idempotent statement in SQL -- or would polute the PrepareIndex.sql -- This file is executed only if the current schema is in revision 2 and it is executed -- before PrepareIndex.sql that is idempotent. DO $body$ BEGIN BEGIN ALTER TABLE AttachedFiles ADD COLUMN customData TEXT; EXCEPTION WHEN duplicate_column THEN RAISE NOTICE 'column customData already exists in AttachedFiles.'; END; END $body$ LANGUAGE plpgsql;