| Subject | FB 2.5.2 trigger doesn't fire |
|---|---|
| Author | Rick Debay |
| Post date | 2012-12-11T17:00:30Z |
CREATE EXCEPTION E '';
CREATE TRIGGER T_TEST_BEFORE FOR T ACTIVE BEFORE INSERT POSITION 0 AS
begin
EXCEPTION E 'TEST BEFORE';
End
CREATE TRIGGER T_TEST_AFTER FOR T ACTIVE AFTER INSERT POSITION 0 AS
begin
EXCEPTION E 'TEST AFTER';
End
Inserting into the table T does not throw an exception.
The database was restored from a backup from a 1.5.6 database.
CREATE TRIGGER T_TEST_BEFORE FOR T ACTIVE BEFORE INSERT POSITION 0 AS
begin
EXCEPTION E 'TEST BEFORE';
End
CREATE TRIGGER T_TEST_AFTER FOR T ACTIVE AFTER INSERT POSITION 0 AS
begin
EXCEPTION E 'TEST AFTER';
End
Inserting into the table T does not throw an exception.
The database was restored from a backup from a 1.5.6 database.