[firebird-support] RE: FB 2.5.2 trigger doesn't fire

[Rick Debay]

Creating a new test table with triggers, the trigger fires.
Adding triggers to existing tables (restored from 1.5.6), nothing fires.

Perhaps I need to backup using the 2.5.2 gbak???

-----Original Message-----
From: Rick Debay 
Sent: Tuesday, December 11, 2012 12:01 PM
To: firebird-support@yahoogroups.com
Subject: FB 2.5.2 trigger doesn't fire

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.