#61 R252: Drop Triggers

R2.5.2
closed-fixed
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!

     
  • 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
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks