At 04:05 PM 18/04/2004 +0000, you wrote:

>--- In firebird-support@yahoogroups.com, "kfkong" <kfkong@y...> wrote:
> > I am trying to upgrade my existing Firebird db. However due to some
> > tables modification and update statement may fire my triggers which
> > will end up disturbing or even corrupting my existing data on
> > another table. Is there a way that I can
> > switch all triggers off during my FB DB upgrade?
>
>ALTER TRIGGER xxx INACTIVE
>
>But it would be more practical to build a new blank database, and pump
>the data from the old one. That way you can monitor what is going on.

But active Before/After Insert triggers would still fire during a pump...

/heLen