X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fshop_orders_update_1.sql;h=e87b40ef3ba87d269d5173ce9500c2d44022f277;hb=670a6e6cb58ccaef212150406b66a955295fe074;hp=b5f205dbd04d13752ba74d9ba5dd48e04a64aba3;hpb=b2bedb6b5eff41a17ddb194df1c75213b841f3bb;p=kivitendo-erp.git 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;