From 5ee95a8f01b5854ca9d5acf5d80c23dbe564c19f Mon Sep 17 00:00:00 2001 From: =?utf8?q?Sven=20Sch=C3=B6ling?= Date: Fri, 10 Aug 2012 10:05:04 +0200 Subject: [PATCH 1/1] =?utf8?q?Nat=C3=BCrlich=20nur=20die=20sub=5Fmodules?= =?utf8?q?=20auf=20''=20setzen,=20die=20auch=20NULL=20sind.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql b/sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql index 3382a58b3..feef5aa24 100644 --- a/sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql +++ b/sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql @@ -2,7 +2,7 @@ -- @description: sub_module in custom_variables auf NOT NULL ändern. -- @encoding: utf-8 -- @depends: release_2_7_0 -UPDATE custom_variables SET sub_module = ''; +UPDATE custom_variables SET sub_module = '' WHERE sub_module IS NULL; ALTER TABLE custom_variables ALTER COLUMN sub_module SET DEFAULT ''; ALTER TABLE custom_variables ALTER COLUMN sub_module SET NOT NULL; -- 2.20.1