Subject Re: [Firebird-Architect] On connect/disconnect trigger
Author Pavel Cisar
Hi,

Dimitry Sibiryakov wrote:
> On 2 Jun 2006 at 9:12, Dmitry Yemanov wrote:
>
>> tracker. But I'm not sure I like the term "trigger" in this context.
>> Such an object has enough semantical differences from a regular
>> trigger. It doesn't have OLD/NEW contexts, it doesn't make sense to
>> have before connect/after disconnect triggers, etc.
>
> Not sure about before connect, but OLD and NEW contexts could be
> useful if they include connection params.

In fact, they could be regular triggers if we would have system table(s)
to log certain system evens like database attachments, transaction
starts etc. They may have persistent content (real audit trail) or just
temporary (like new system tables in IB7). By creating user triggers on
these tables, people can achieve what they want.

best regards
Pavel Cisar
IBPhoenix