Subject | Re: [firebird-support] When do triggers take effect? |
---|---|
Author | Helen Borrie |
Post date | 2016-06-06T20:03:42Z |
Hello Tim,
Tuesday, June 7, 2016, 2:59:03 AM, you wrote:
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.
Helen
Tuesday, June 7, 2016, 2:59:03 AM, you wrote:
> Using Database Workbench I added a trigger to a table, but it didn'tA new or altered trigger won't take effect until the cache is cleared.
> 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?
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.
Helen