blob: fbf24c448519b9f4a47a3df0c37998f405f0fe48 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
ALTER TABLE releases ALTER COLUMN l_dmm DROP DEFAULT;
ALTER TABLE releases ALTER COLUMN l_gyutto DROP DEFAULT;
ALTER TABLE releases_hist ALTER COLUMN l_dmm DROP DEFAULT;
ALTER TABLE releases_hist ALTER COLUMN l_gyutto DROP DEFAULT;
ALTER TABLE releases ALTER COLUMN l_dmm TYPE text[] USING CASE WHEN l_dmm = '' THEN '{}' ELSE ARRAY[l_dmm ] END;
ALTER TABLE releases ALTER COLUMN l_gyutto TYPE integer[] USING CASE WHEN l_gyutto = 0 THEN '{}' ELSE ARRAY[l_gyutto] END;
ALTER TABLE releases_hist ALTER COLUMN l_dmm TYPE text[] USING CASE WHEN l_dmm = '' THEN '{}' ELSE ARRAY[l_dmm ] END;
ALTER TABLE releases_hist ALTER COLUMN l_gyutto TYPE integer[] USING CASE WHEN l_gyutto = 0 THEN '{}' ELSE ARRAY[l_gyutto] END;
ALTER TABLE releases ALTER COLUMN l_dmm SET DEFAULT '{}';
ALTER TABLE releases ALTER COLUMN l_gyutto SET DEFAULT '{}';
ALTER TABLE releases_hist ALTER COLUMN l_dmm SET DEFAULT '{}';
ALTER TABLE releases_hist ALTER COLUMN l_gyutto SET DEFAULT '{}';
|