projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
Dialogbuchen: Konto beim Entfernen von Zeilen richtig setzen
[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;