Subject Re: [Firebird-Architect] Database triggers
Author Jim Starkey
Leyne, Sean wrote:
> You'll note that the syntax provides for <type> which denotes a special
> class of trigger.
> I'm just saying that it makes more sense to relate the system triggers
> with the RDB$Database table, since the triggers will be in the context
> of the database.
> Can you think of any reason why a developer would create a trigger on
> the RDB$Database table?
> It seems to be a better solution than creating a new table just for this
> purpose.

It doesn't make any sense at all. RDB$DATABASE doesn't have any of the
information that a connection trigger requires.

Hint: If you started with the problem rather than a solution, this sort
of thing would be more clear.


Jim Starkey, Senior Software Architect
978 526-1376