WebshopApi: Fehlerhaftes Updatescript berichtigt

[kivitendo-erp.git] / sql / Pg-upgrade2 / shop_orders_update_1.sql

diff --git a/sql/Pg-upgrade2/shop_orders_update_1.sql b/sql/Pg-upgrade2/shop_orders_update_1.sql
index b5f205d..e87b40e 100644 (file)
--- a/sql/Pg-upgrade2/shop_orders_update_1.sql
+++ b/sql/Pg-upgrade2/shop_orders_update_1.sql
@@ -12,7 +12,7 @@ CREATE OR REPLACE FUNCTION update_shop_orders_on_delete_oe() RETURNS TRIGGER AS
   BEGIN
     UPDATE shop_orders SET oe_trans_id = NULL WHERE oe_trans_id = OLD.id;
 
-    RETURN OLD.id;
+    RETURN OLD;
   END;
 $$ LANGUAGE plpgsql;