570
|
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;
|