X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Frequirement_specs.sql;h=be7acb5e27519de8a12dcc1d95b76448174d1909;hb=07a735e0cb464b4cf96617578868957635410ad9;hp=7647c2e91e510ee1cad412e4aa6f3b9543bf3778;hpb=640adf5897913667b2b50148cc651bacafb0481e;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/requirement_specs.sql b/sql/Pg-upgrade2/requirement_specs.sql index 7647c2e91..be7acb5e2 100644 --- a/sql/Pg-upgrade2/requirement_specs.sql +++ b/sql/Pg-upgrade2/requirement_specs.sql @@ -279,9 +279,9 @@ CREATE OR REPLACE FUNCTION update_requirement_spec_item_time_estimation(item_id SELECT * INTO item FROM requirement_spec_items WHERE id = item_id; RAISE DEBUG 'updateRSIE: item_id % item_type %', item_id, item.item_type; - IF (item.item_type = 'section') OR (item.item_type = 'sub-function-block') THEN - -- Don't do anything for sections and sub-function-blocks. - RAISE DEBUG 'updateRSIE: this is a section/sub-function-block, not updating.'; + IF (item.item_type = 'sub-function-block') THEN + -- Don't do anything for sub-function-blocks. + RAISE DEBUG 'updateRSIE: this is a sub-function-block, not updating.'; RETURN FALSE; END IF;