|Subject||RE: [Firebird-Architect] Database triggers|
|Author||Claudio Valderrama C.|
> -----Original Message-----Also, user triggers on sys tables work only until everybody disconnects from
> 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.
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.