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
MySQL AB, www.mysql.com
978 526-1376