X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Frequirement_spec_items_update_trigger_fix2.sql;h=9f714da7e5976a02ffef904df34b65c15456111c;hb=97a6f6d623a9810e1d324f44a5f8bcd12294f5d3;hp=fd9729f2f00ec2df3750c1fb2ef4a9d4987c796b;hpb=f99e8aa3bdb4b7ac94730952287b4f77f1f9a573;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/requirement_spec_items_update_trigger_fix2.sql b/sql/Pg-upgrade2/requirement_spec_items_update_trigger_fix2.sql
index fd9729f2f..9f714da7e 100644
--- a/sql/Pg-upgrade2/requirement_spec_items_update_trigger_fix2.sql
+++ b/sql/Pg-upgrade2/requirement_spec_items_update_trigger_fix2.sql
@@ -6,7 +6,12 @@
 -- children. item_id is the ID of the item that needs to be updated
 -- (or NULL if the requirement spec itself must be updated/a section
 -- was changed).
-CREATE OR REPLACE FUNCTION update_requirement_spec_item_time_estimation(item_id INTEGER, item_requirement_spec_id INTEGER) RETURNS BOOLEAN AS $$
+
+-- This function must be dropped manually because PostgreSQL cannot
+-- rename function parameters with 'CREATE OR REPLACE FUNCTION ...'
+-- anymore.
+DROP FUNCTION update_requirement_spec_item_time_estimation(item_id INTEGER, requirement_spec_id INTEGER);
+CREATE FUNCTION update_requirement_spec_item_time_estimation(item_id INTEGER, item_requirement_spec_id INTEGER) RETURNS BOOLEAN AS $$
   DECLARE
     current_row RECORD;
     new_row     RECORD;
@@ -18,7 +23,7 @@ CREATE OR REPLACE FUNCTION update_requirement_spec_item_time_estimation(item_id
          OR ((key = 'deleting_requirement_spec')      AND (value = CAST(item_requirement_spec_id AS TEXT)))
       LIMIT 1
     ) THEN
-      RAISE DEBUG 'updateRSIE: item_id % or requirement_spec_id % is about to be deleted; do not update', item_id, requirement_spec_id;
+      RAISE DEBUG 'updateRSIE: item_id % or requirement_spec_id % is about to be deleted; do not update', item_id, item_requirement_spec_id;
       RETURN FALSE;
     END IF;