Subject | Re: [firebird-support] Table transactional triggers |
---|---|
Author | Vlad Khorsun |
Post date | 2009-05-01T17:39:33Z |
> Is it possible to have a trigger fire for an insert/update/delete onlyNo
> after all changes to the table have been committed?
> I'm not up-to-date on 2.0 - 2.5 so I may have missed itYou could use ON TRANSACTION COMMIT trigger with, probably,
help of RDB$SET_CONTEXT\RDB$GET_CONTEXT functions. But it
fire at transaction commit time, not after. If you need after commit -
use events.
Regards,
Vlad