Subject RE: [Firebird-Architect] Database triggers
Author Claudio Valderrama C.
> -----Original Message-----
> From: Firebird-Architect@yahoogroups.com
> [mailto:Firebird-Architect@yahoogroups.com]On Behalf Of Ann W. Harrison
> Sent: Martes, 19 de Septiembre de 2006 18:14
>
> Martijn Tonies wrote:
> >> Can you think of any reason why a developer would create a trigger on
> >> the RDB$Database table?
> >
> > Well, given that triggers on system table don't "stick", no.
> >
>
> That could be fixed. It's really a gbak problem / quirk.

Also, user triggers on sys tables work only until everybody disconnects from
that db.
When you define a user trigger in a sys table, it's loaded and works.
After all attachments to that db are closed, the server "unloads" the db.
If you connect again, when the server loads the db, it doesn't load user
triggers on sys tables.

C.