From 35617a68898e491aec8cdc12a8036b1632030bf2 Mon Sep 17 00:00:00 2001 From: Werner Hahn Date: Tue, 26 Sep 2017 17:00:23 +0200 Subject: [PATCH] WebshopApi: Fehlerhaftes Updatescript berichtigt --- sql/Pg-upgrade2/shop_orders_update_1.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/Pg-upgrade2/shop_orders_update_1.sql b/sql/Pg-upgrade2/shop_orders_update_1.sql index b5f205dbd..e87b40ef3 100644 --- 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; -- 2.20.1