Subject | RE: FB 2.5.2 trigger doesn't fire |
---|---|
Author | Rick Debay |
Post date | 2012-12-11T17:24:56Z |
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.
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.