Subject RE: [firebird-support] Re: triggers on rdb$ system tables, access violation
Author Alan McDonald
> > FYI: triggers on system tables (including on rdb$triggers and
> > rdb$procedures)
> > seem to get dropped the moment I issue a "drop table" command. They
> > stick around
> > during "create table" though, and will stay active while I create new
> > procedures
> > and triggers. "drop", however, seems to have some extra side-effects.
> > No idea if
> > that's intentional or not.
> >
> > -Philip
>
> it's no accident
> Alan
>

what I would look at is the flags for the triggers you create to see if
setting them to something matching the flags of other system objects, would
stop them being dropped.
Alan