Subject Re: [firebird-support] When do triggers take effect?
Author Nick Upson
you need to commit the trigger creation / modification & then have any other relevant transaction commit

Nick Upson,
Principal Operations Engineer, Telensa Ltd.
Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200

On 6 June 2016 at 15:59, Tim Ward tdw@... [firebird-support] <> 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?

Tim Ward