Subject | RE: [firebird-support] Re: triggers on rdb$ system tables, access violation |
---|---|
Author | Alan McDonald |
Post date | 2009-02-16T21:34:56Z |
> > FYI: triggers on system tables (including on rdb$triggers andwhat I would look at is the flags for the triggers you create to see if
> > 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
>
setting them to something matching the flags of other system objects, would
stop them being dropped.
Alan