[Reservations]Fix pg compatibility issue in trigger.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Tue, 23 Oct 2012 10:05:10 +0200
changeset 18655 67a495fee94a
parent 18654 b3d7dbd042f7
child 18656 bbe2cd86c639
[Reservations]Fix pg compatibility issue in trigger.
src-db/database/model/triggers/M_RESERVATION_STOCK_TRG.xml
--- a/src-db/database/model/triggers/M_RESERVATION_STOCK_TRG.xml	Mon Oct 22 16:22:50 2012 +0200
+++ b/src-db/database/model/triggers/M_RESERVATION_STOCK_TRG.xml	Tue Oct 23 10:05:10 2012 +0200
@@ -43,6 +43,7 @@
   SET reservedqty = COALESCE(reservedqty, 0) + v_reservedqtydiff,
       releasedqty = COALESCE(releasedqty, 0) + v_releasedqtydiff
   WHERE m_reservation_id = v_reservation_id;
-END]]></body>
+END M_RESERVATION_STOCK_TRG
+]]></body>
     </trigger>
   </database>