Subject Re: [firebird-support] When do triggers take effect?
Author Helen Borrie
Hello Tim,

Tuesday, June 7, 2016, 2:59:03 AM, you wrote:

> Using Database Workbench I added a trigger to a table, but it didn't
> seen to do anything (in particular didn't throw an exception which it
> should have done when I deliberately created an invalid record).

> After restarting DBWB the trigger behaved as expected.

> Do triggers not take effect on existing connections, or something?

A new or altered trigger won't take effect until the cache is cleared.
With Classic, this means the next new connection as each has its own
private cache. With SS, shared cache, so the cache isn't cleared
until all users are logged off.