#61 R252: Drop Triggers

R2.5.2
closed-fixed
Jorg Janke
7
2005-03-04
2005-03-04
Jorg Janke
No

The migration should have deleted all triggers. In some
cases this did not happen.
You need to delete the standard triggers for R252
manually.

The attached script deletes all triggers. We cannot run
this automatically as it will also drop custom triggers.
So only run the scrupt, if you have no custom triggers.
---
Please check CVS for any update of the script!

http://cvs.sourceforge.net/viewcvs.py/compiere/db/mainta
in/Maintenance/8_DropTrg.sql

---

Title: Delete all triggers
Description:
This scrpt deletes all triggers of a user - DANGEROUS !!!

Make sure that you run this script ONLY
- with a migrated DB if Compiere Release 2.5.1g or later
- with the Compiere user
- when you have a backup

Execute:
- sqlplus compiere/compiere @8_DropTrg.sql

Discussion

  • Jorg Janke
    Jorg Janke
    2005-03-04

    Drop Trigger Script - read prerequisites!

     
    Attachments
  • Jorg Janke
    Jorg Janke
    2005-03-04

    • labels: --> Database.sql
    • milestone: --> R2.5.2
    • priority: 5 --> 7
    • assigned_to: nobody --> jjanke
    • status: open --> closed-fixed